on 16 Nov 2017 22:01:19
Currently, conditional formatting in matrix is based on all values of the matrix. I am looking forward to have it based on individual rows (a feature already available in Excel)
Consider having monthly data (column) which you want to track for multiple categories (rows). But the categories have completely different values (i.e. some rows with $10 on average and some rows with $1000 on average).
By applying conditional formatting per row, you can track trends/behaviour per individual category.
Now the row with the highest values ($1000 row in above example) will typically steal all the highlights, and not allow you to see any color changes in rows which have much lower values (yet can still have trends)
The only current "trick" is to transform the data as a percentage of row total (%). However, then you can still face problems if you have some outliers in a specific row.
- Comments (18)
RE: Matrix: conditional formatting per row in matrix
I have a list of services I display with their features in a matix and I need to use conditional formatting across the row using a value from the row header
RE: Matrix: conditional formatting per row in matrix
Would be great to have this option !
RE: Matrix: conditional formatting per row in matrix
This feature would really hwlp, I'm trying to solve the same issue and can't find a way
RE: Matrix: conditional formatting per row in matrix
Multiple metrics in a matrix and the visual strength of conditional formatting per metric is not possible. This would be very helpful to have.
RE: Matrix: conditional formatting per row in matrix
Any progress on this topic yet?
RE: Matrix: conditional formatting per row in matrix
lets do this please, its a simple thing that adds much value in reports
RE: Matrix: conditional formatting per row in matrix
Can't believe it is still not possible to apply conditional formatting to rowheaders in a matrix. How is anyone ever gonna make a semi decent looking PnL in Power Bi without it!?
Let's get go MS!
RE: Matrix: conditional formatting per row in matrix
I am currently have the same concern. I hope to get answer soon.
RE: Matrix: conditional formatting per row in matrix
I would love to know how to do this in excel.
RE: Matrix: conditional formatting per row in matrix
Microsoft Admin: Is this thread largely encapsulated within https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12898575-in-table-matrix-visualisations ? If so, can you please roll them into one, and possibly include https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6795573-sparkline so that they get the combined weight in your prioritization that they deserve?