Forum Discussion
Solved
Conditional Formatting Matrix Columns
Hello, I am trying to figure out if there is a way to use conditional formatting to go on the basis of the column, rather than the entirety of the matrix. For example, when I use the Lowest v...
Conditional formatting applies to a range of values in a single column of your original table, when you create a Matrix visual using fields of the original table, all values come from this single column, thus conditional formatting goes on the entirety of the Matrix.
The feature you describe can’t be achievable in Power BI Desktop, you can submit a feature request in the Power BI ideas forum: https://ideas.powerbi.com/forums/265200 .Thanks,
Lydia Zhang
For anyone searching, the below works:
Formatting Measure =
RANKX (
ALLSELECTED ( Matrix Rows ),
[Matrix Measure],
[Matrix Measure],
ASC
)
I don't understand why the measure is in there twice, or what it's doing. But I know it works.
If you have a very narrow range of values, the highlighting effect won't be very pronounced.