Conditional Formatting for Text in Matrix

[krixtsup3r]

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:

[amitchandak]

@krixtsup3r , 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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[krixtsup3r]

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]

@krixtsup3r 

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/change-the-color-of-the-data-value-of-quot-card-component-q...

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.

[krixtsup3r]

Hi @Anonymous, thank you! but I am looking for something in Matrix not in Card 😞