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!
