Forum Discussion
Conditional Formatting on Count %RT
HI pattaninlua ,
To resolve the issue, first create a measure to calculate the count of the relevant field. Then, build a separate percentage measure based on that count, ensuring it reflects the proportion of each category within the selected context and is formatted as a percentage. Next, create a color measure that assigns different colors depending on the percentage thresholds, making sure totals or grand totals are excluded if needed. In your matrix visual, replace the existing percentage field with the new percentage measure, and apply conditional formatting using your color measure. To do this, choose background color formatting, set the format style to 'Field value', apply it to values only, and select the color measure as the field to base the formatting on. This approach ensures that conditional formatting correctly reflects the percentage measure rather than raw counts.
Find the below attached .pbix file for your reference.
Thank you.
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 "
)
)
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
If any other method is more helpful, I am happy to hear