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:
For now I managed to change the color to green if the total is >= 12. But the thing is that I don't know how to add another condition which is the background color will only change if the total include the Health Screening
Is it possible to do this in Power BI Desktop? If yes, can you teach me how to do this.
Thanks in advance!
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?
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 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/
mmbr1606
9
Super User 2025 Season 1
stampcoin
7
SD-13050734-0
6