Forum Discussion
conditional formatting for each column in matrix
Super UserAnonymous , 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
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