Forum Discussion
Power BI - Add background color in matrix table based on condition
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!
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.
4 Replies
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: [email protected]
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/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.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! 🙂
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?