Dark and Light mode Power BI report with switch - No bookmarks!
Create a dark and light mode version of your Power BI report without bookmarks. Follow me on how I create a version for Workout Wednesday (Week 37, 2024).
Website Workout Wednesday: https://workout-wednesday.com/
Dark and Light Mode Workout: https://workout-wednesday.com/pbi-202...
Dynamically change colors in Power BI video: • Dynamically change colors in Power BI usin...
DAX and Data below the timestamp!
---------------------------------
⏰ TIMESTAMPS
---------------------------------
04:23 Date Table & Color Table - 6:10
05:30 Change color codes (make sure you watch the video)
06:25 Relationship between Date and data table
07:00 Creating the report (basic visuals)
07:35 Filter the report
08:00 Card: Current Year Sales
08:30 Card: Year over Year %
09:41 Bar Chart with error bar markers
11:12 Second bar chart
12:11 Region Slicer
13:00 Adding a background shape and using conditional formatting
14:05 Adding the new slicer visual
16:00 Adding a header
17:20 Adding a dynamic header
18:40 Font Conditional formatting
19:25 Sales & Sales YoY Conditional formatting
21:30 DAX YoY formatting
24:35 Format Painter & Power BI
29:00 Shapes as a legend
30:08 Empty Character
Oeps 30:30 Totally forgot about the filter.
#powerbi #PowerBITutorial #powerbidesktop #PowerBITraining #powerbitips #Reports #powerbideveloper
____________________
Data & DAX
____________________
DAX:
_Sales = SUM('Sample - Superstore with Manufacturer'[Sales])
LY Sales = CALCULATE([_Sales],SAMEPERIODLASTYEAR('Date'[Date]))
Sales YoY = Divide([_Sales]-[LY Sales],[LY Sales])
DAX Title Report = MAX('Date'[Year]) & " Sales Report"
Date Table
Download (txt file) https://www.valeriejunk.nl/download/1...
Color Table
Mode Mode Icon Background Canvas Background Visual Border Visual Main Color Visuals Highlight Color Visual Font
Light ☀️ #e5eaf2 #f8fafc #f8fafc #0b3669 #576c8c #323447 #0b3669 #605e5c
Dark 🌙 #474c5b #212337 #212337 #78afec #de9742 #dce2e2 #78afec #605e5c
---------------------------------
😊JOIN
----------------------------------
Website https://www.porcu.bi
LinkedIn / valeriejunk
X / porcubi