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 (16)
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?
RE: Matrix: conditional formatting per row in matrix
Currently you can wrap all the measures into a single 'magic measure' which uses a switch statement and a disconnected 'column dimension' table to control which measures go into which columns. Then use the 'Magic Measure' to apply conditional formatting to each row. This avoids having to apply conditional formatting separately to each column value. - You will also need a separate measure that drives conditional formatting, if you want to do anything other than colour range formatting, e.g. KPI, or highlight specific rows with an indicator / boolean measure.
RE: Matrix: conditional formatting per row in matrix
looking forward to this too!!!