Forum Discussion
Anonymous
5 years agoNot applicable
Conditional Formatting based on 2 dimensions
Hi, Below is how my data is structured. I have an KPI and for the KPI to be "Met" 2 it shoud meet the 2 conditions below. The conditions are as below: Condition 1: At Global level the score should ...
amitchandak
5 years agoSuper User
Anonymous , Create a color measure
color = if([Score]<= 80 ,"red", "white")
And you have to do it for all columns. Go to conditional formatting for each column choose font formatting and under that use "field values" and select this color measure
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values