Give a different background colour or font colour based on text in Power BI report scene/page

[Dersim]

Hello All,

I have a risk ratings column in the Power BI.

I want to give a background colour based on each Risk ratings’ value. Such as for Minor, the background should be green, for Moderate, the background should be yellow, for Major, background should be Amber and for Critical, the background should be red colour.

Please see the screenshot below for better explanation.

 

Thank you for reading and for any replies.

[amitchandak · Accepted solution]

@Dersim , You can use color measure for that in conditional formatting using the field value option. But that will not work on Matrix row or column. In matrix, it will work for only values. Table it work for all columns

Color Measure = Switch(Max(Table[Risk Rating]) ,

"Minor", "Green",

"Moderate","Yellow",

"Major", "Yellow"

"Critical", "red"

)

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[v-kkf-msft · Accepted solution]

Hi @Dersim ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[amitchandak · Accepted solution]

@Dersim , You can use color measure for that in conditional formatting using the field value option. But that will not work on Matrix row or column. In matrix, it will work for only values. Table it work for all columns

Color Measure = Switch(Max(Table[Risk Rating]) ,

"Minor", "Green",

"Moderate","Yellow",

"Major", "Yellow"

"Critical", "red"

)

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4