Forum Discussion
conditional formatting for each column in matrix
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?
2 Replies
- amitchandak
Super User
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-valuesSorry 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
