Forum Discussion
conditional formatting per column
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , You can create a color measure using switch and can use that in conditional formatting using 'Filed value option
Switch( True() ,
max(Table[high]) <=10 , "Green",
max(Table[high]) <=20 , "yellow",
"red"
)
Same way you can create other measures or combined measures.
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
Hi there,
Thank you for your help.
I'm sorry I dont fully understand the process as explained above. Could you provide more detail? What do i do once I have created a measure with the above DAX code?
Cheers