Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have the following columns are Id, Code, Result1, Result2, Result1 colour code and Result colour code in data table.
For Result1 and Resul2 created slicer table for switch the Results in visual and the same way created measure for value columns in matrix table .
Data:
ID | Code | Result1 | Result2 | Result colour code | Result2 colour code |
1S | A | Win | Id1 | Green | Green |
1S | A | Win | Id1 | Green | Green |
1S | B | Win | Id1 | Green | Green |
1S | C | Win | Id1 | Green | Green |
1S | D | Win | Id1 | Green | Green |
1S | D | Win | Id1 | Green | Green |
2S | A | Loss | Id2 | Red | Red |
2S | B | Loss | Id2 | Red | Red |
2S | C | Loss | Id2 | Red | Red |
2S | D | Loss | Id2 | Red | Red |
3S | A | Loss | Id3 | Red | Orange |
3S | A | Loss | Id3 | Red | Orange |
4S | A | Win | Id4 | Green | Yellow |
4S | A | Win | Id4 | Green | Yellow |
5S | A | Win | Id5 | Green | Purple |
5S | B | Win | Id5 | Green | Purple |
6S | C | Loss | Id6 | Red | Blue |
6S | D | Loss | Id6 | Red | Blue |
AlexisOlson helped for slicer and measure
If I selected the Result1 status in slicer table then it will reflect Result1 status and row/columns only and the same thing for Result2.
Now my question is how can I apply the conditional according to the result.
Measure:
Slicer
PBI file attached.
Solved! Go to Solution.
Define a similar color measure.
VarColor =
SWITCH (
SELECTEDVALUE ( Slicer[Result] ),
"Result 1", SELECTEDVALUE ( REPORT[Result colour code] ),
"Result 2", SELECTEDVALUE ( REPORT[Result2 colour code] )
)
Then use that in the conditional formatting.
Define a similar color measure.
VarColor =
SWITCH (
SELECTEDVALUE ( Slicer[Result] ),
"Result 1", SELECTEDVALUE ( REPORT[Result colour code] ),
"Result 2", SELECTEDVALUE ( REPORT[Result2 colour code] )
)
Then use that in the conditional formatting.
Hi. Thanks for your reply and sorry for the late response.
Your solution is working well.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |