Forum Discussion
conditional formatting per column
I have a table which shows the number of car crashes for each car within with 3 columns - HIgh, Medium, low.
I want to add conditional formatting to each cell. The conditions are for the background color to changes depending on the numerical value in the cell. But these thresholds CANT BE the SAME for each column.
Example:
High Column: 0 to 10 = Green Background ; 11 to 20 = Yellow Background ; 22 to 30+ = Red Background
Medium Column: 0 to 20 = Green Background ; 21 to 49 = Yellow Background ; 50+ = red background
Is there any way to apply conditional formatting to each column rather than the entire table?
thanks guys
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.
6 Replies
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-valuesHi Anonymous ,
Try to use the feature.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
