conditional formatting per column

[Anonymous]

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

[v-lionel-msft]

Hi @Anonymous ,

Try to use the feature.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Here is the visual :

notice how the columns are an option for conditional formatting? just the values for the table.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi there,

Thanks this is very helpful.

The issue is that the values are a measure, the columns are high,medium,low. these dont show up as options under the conditional formatting list.

Cheers 

[amitchandak]

@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

[Anonymous]

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