Dynamically change colors in Power BI using Conditional formatting NO BOOKMARKS, NO JSON

Опубликовано: 02 Апрель 2026
на канале: PorcuBI - Valerie Junk

5,417

144

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: https://www.valeriejunk.nl/dynamicall...
Example pbix: https://www.valeriejunk.nl/power-bi-d...
---------------------------------
⏰ 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
https://www.valeriejunk.nl/download/1...

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 https://www.porcu.bi
LinkedIn / valeriejunk
X / porcubi

#powerbi #PowerBITutorial #powerbidesktop #PowerBITraining #powerbitips #Reports #powerbideveloper