Forum Discussion
Conditional Formatting for Text in Matrix
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-values
Hi Sorry 'bout that.
It's adding colors to each status. I first created something like this:
Conditional Color = SWITCH( [Status Measure], "SUBMITTED", "GREEN", "ABSENT", "RED" ....But it doesn't work, also I have many status that I need to have colors as well.
Anonymous
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.Hi Anonymous, thank you! but I am looking for something in Matrix not in Card 😞