Forum Discussion
Solved
Help with conditional formatting!
HI, I have a matrix table (shown below) and I am wanting to conditional format the cells within each column in the following way: - Between -5 and +5, they are highlighted Green - Above +5...
Try:
SWITCH(TRUE(),
[Your measure] < 0.81, "red",
[Your measure] > 1.19, "red,[Your measure] >= 0.95 && [Your measure] <= 1.05, "green",
"orange")
deanbland , you can create a color measure and use that in conditional formatting with Field value option
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
refer for steps
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