Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
From the table above, you can see the first column is colored orange, but it should be white.
Here below is the conditional formatting that I have set up. I have also tried changing the summarization to max and other parameters without success.
Any help?
Solved! Go to Solution.
@BaronSdG , create measure like and try conditional formatting with field value option
isStatus_Color_Background_BetaOrPlanned = SWITCH(max(components[status]),
"b", "red"
,"s", "green"
, "p","Blue" )
refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
@BaronSdG , create measure like and try conditional formatting with field value option
isStatus_Color_Background_BetaOrPlanned = SWITCH(max(components[status]),
"b", "red"
,"s", "green"
, "p","Blue" )
refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Also, why do I need to use MAX in the formula?
Thanks!
I thing to clarify, the measure must be in the table with the filtering letters, otherwise for some reason it doesn't work (the table in the picture I posted was with the actual data), otherwise it doesn't work
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |