conditional formatting for each column in matrix

[Anonymous]

I am trying to apply conditional formatting with specific conditions for each column rather than just the whole visual. Ultimately it comes down to the background of each cell changing depending on the value in the cell. Is this possible in power bi?

[amitchandak]

@Anonymous , exact need is not clear. You can do rule base, Scale base of measure based.

refer to my video: https://www.youtube.com/watch?v=RqBb5eBf_I4

or these blog

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]

Sorry i'll try to clarify. 

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