Dynamically change colors in Power BI using Conditional formatting NO BOOKMARKS, NO JSON
ฝัง
- เผยแพร่เมื่อ 16 ก.ย. 2024
- Using dynamically changing colors gives users more control over the look and feel of a Power BI report. This allows users to choose between a colorful layout or a more minimal black-and-white approach.
Data below timestamps!
Article: www.valeriejun...
---------------------------------
⏰ TIMESTAMPS
---------------------------------
00:05 Why to use this method?
01:20 What we will create during this Power BI tutorial
02:08 Step 1: Choosing colors
04:48 Step 2: Creating the new slicer (buttons)
09:00 Adding another color to the table
11:14 Step 3: Adding a header and changing the background and font color
15:02 Step 4: Changing the background of the canvas
16:34 Step 5: Visual - changing the background, font and border-color
20:50 Adding dynamic highlights in a visual
26:00 Limitations of this method
27:39 Recommendations
---------------------------------
Data
---------------------------------
Columns in the color table
Download a txt file and paste the data into Power BI
www.valeriejun...
Test Data
Year Sales Target Target hit
2022 1000 800 1
2023 2000 2500 0
2024 3000 2800 1
2025 3500 3800 0
DAX Measure
Column DAX = Switch(
True(),
MIN('Example Data'[Target hit]) = 1 , MIN ('Color Table'[Main Color]), MIN('Color Table'[Neutral color]))
---------------------------------
😊JOIN
----------------------------------
Website www.porcu.bi
LinkedIn / valeriejunk
X / porcubi
#powerbi #PowerBITutorial #powerbidesktop #PowerBITraining #powerbitips #Reports #powerbideveloper
This is such a killer technique, and the best part is that it's so simple and easy to implement! I will definitely add this to my Power BI toolbox, and I'll show it to every Power BI report author I meet from now on. Great work, Valerie! 🤩
Glad you like it and find it useful! Since I learned about this it changes so much design struggles for me!
Uitstekende tips, bedankt. I have forgotten about referring to colour values in a table!
Thank you!
Cool idea. Thanks for sharing.
Thank you so much!
Data set link for practice 😊
Hi, you can find the data I used in the description, when you follow the steps in the video you should see the same result!
@@PorcuBI thank u so much do more content begginer to advanced lesson really helpful.. u really great