Forum Discussion
Conditional Formatting for Text in Matrix
Hi Guys,
Just need help on adding the conditional formatting on my matrix that has text value. The value is a measure that I created.
I already tried using switch or creating a helper column to do formatting but it only captures one value.
Below is the measure I used:
Status_Measure =
IF(
MAX(Submission[ReStatus]) = BLANK(),
IF(
SELECTEDVALUE('Date Reference'[DAY NAME]) = SELECTEDVALUE(RestDay[Day]),
"Out of Office", "No Entry"),
MAX(Submission[ReStatus]))
Below is my matrix:
Also, below is how I related each table:
4 Replies
Anonymous , I am not clear what help you need. Is the measure correct and you want to color group.
If Measure is correct and you want to color group. Then Create a similar measure which will now return color instead of status. And use that in conditional formatting after choosing field option.
Example
color = switch ( true(), FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen", FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen", /// Add more conditions "red" )Refer for steps
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesAnonymous
Power bi Conditional format doesn't support Text in any default visuals. As a workaround, you may try the Card with States Custom Visual. See the similar posts:
https://community.powerbi.com/t5/Desktop/conditional-font-color-in-card/td-p/223172
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
