Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |