Power BI - Add background color in matrix table based on condition

[Syndicate_Admin]

Hi I need help on how can I add background color in my matrix table based on condition. 

The condition is:

1. Those who get at least 12 and above in total, the background color should be green (total >= 12, background color=green, else will stay as default color)

2. The green background color is ONLY applicable for those who took AT LEAST 1 for Health Screening pillar

3. The end result should be like this: (total >= 12, background color=green, ONLY IF 1 Health Screening has been taken)

Refer to my screenshot below:

Is it possible to do this in Power BI Desktop? If yes, can you teach me how to do this.

Thanks in advance!

[v-jingzhang · Accepted solution]

Hi @Syndicate_Admin 

If it's a matrix visual, you can create the following measure for the background color. When setting the background color, select Format style "Field value" based on this measure and apply it to "Totals only". 

BG Color = IF(SUM('Table'[Value])>=12 && CALCULATE(SUM('Table'[Value]),'Table'[Category]="Health Screening")>=1, "#00FF00")

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Syndicate_Admin]

Hi @Syndicate_Admin , I have a question. Based on my previous question and your solution, is it possible if I want to count the total green?

[Syndicate_Admin]

Hi @Syndicate_Admin , I tried this method and it works!! Really appreciate your assistance. Thank you so much and hope you have a good day! 🙂

[Syndicate_Admin]

Hi Nbz78,

I think this post will help in solving your problem.

Let me know if I can provide you with more details

Thanks

Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/