Conditional Formatting on Count %RT

[pattaninlua]

Hi, 

There was a request to add conditional formatting to the following Matrix (Cropped to remove confidential name features) to highlight when values are above 50% 

The percentages were formed from using %RT as shown here

From previous attempts, I have tried to apply conditional formatting but it seems to apply to the total count rather than to count % (I also have a table next to this one which shows that).

Is there a way to do this?

Notes:

The counts are items in column (upc_id) which I have created a measure as follows: countSKUs = count(table[upc_id])

The row columns are items in column (Status 1)

[cengizhanarslan]

Select the matrix → Format pane → Conditional formatting (Background color or Font color) for the value you want:

• Format by: Field value

• Based on field: RT Color

[pattaninlua]

I have tried that already but there is no option to select %RT in Field.

Another option would be much apreciated

[amitchandak]

@pattaninlua , While apply you have option where to apply or GT or all rows. 

You can create a measure like below and use that in conditional formatting in font or background 

If([% RT] >=.5 , "Red", "Green") 

If you want to hide the number, use "#FFFFFF00" or have the same color for font and background. Use this in conditional formatting using the field value option 

[pattaninlua]

for [% RT], how does one achieve this? I cannot seem to create a separate measure for [% RT] values

[amitchandak]

@pattaninlua , You can use Any measure which you have Like [RT % COuntSKUs] and can have various logics 

These are just examples

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) < date(2022,04,10) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .75 , "Amber" ,
"Red "
) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)

Color = Switch( True() ,
Max(Table[Status]) < 200 ,
Switch(true(),
[ERB] = .25 , "Orange" ,
"Red "
) ,
Max(Table[Status]) < 500 ,
Switch(true(),
[ERB] = .25 , "Orange" ,
"Red "
) ,
Switch(true(),
[ERB] = .25 , "Orange" ,
"Red "
)
)

[pattaninlua]

Still unable to do so, I have created this measure but when I try to add the conditional formatting, it does not allow me to select the measure

color = if(FIRSTNONBLANK('pricing_index_test'[upc_id],[countSKUs]) < 0.5 ,

Switch(true(),

[countSKUs] >= .6 , "Green" ,

[countSKUs] >= .4 , "Amber" ,

"Red "

))

If any other method is more helpful, I am happy to hear

[amitchandak]

@pattaninlua , use the field value option 
Only Text Measures