Forum Discussion
How to set conditional formatting based on different numbers
Hi All,
A simple question on conditional formatting, how can I set conditional formatting based on different numbers? Basically, they are the different columns of a table, I just want columns Jul to Jan data reflect different color against the Target column, I am not sure whether it's possible.
Please note my table is just base on the query data instead of using any of the DAX. If DAX can help with my request, please help share also. Thanks!
Hi ST123 ,
I suggest you to create color measures for each column and then set conditional formatting in cell elements.
For reference: Apply conditional formatting in tables and matrixes
My Sample:
I use Field value for Format stype in background color.
Measure:
Jul Color = IF(SUM('Table'[Jul])>=SUM('Table'[Target]),"Green","Red")Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi ST123 ,
I suggest you to create color measures for each column and then set conditional formatting in cell elements.
For reference: Apply conditional formatting in tables and matrixes
My Sample:
I use Field value for Format stype in background color.
Measure:
Jul Color = IF(SUM('Table'[Jul])>=SUM('Table'[Target]),"Green","Red")Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
This is exactly what I want, I didn't know can do like this way. Thanks!
