Matrix: conditional formatting per row in matrix
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.
Edwin de Ligter commented
Multiple metrics in a matrix and the visual strength of conditional formatting per metric is not possible. This would be very helpful to have.
lars crauwels commented
Any progress on this topic yet?
lets do this please, its a simple thing that adds much value in reports
Lasse Matthias commented
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!
I am currently have the same concern. I hope to get answer soon.
I would love to know how to do this in excel.
jeffrey Weir commented
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?
Dan Thompson commented
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.
looking forward to this too!!!
I agree, conditional formatting based on any criteria (not just values) would be very helpful. For example, I have a table with a column flag of "Late" (for customer deliveries). I'd like to highlight each of these rows as RED, so they jump off the page.
This is a very good idea and we request Microsoft team to implement this as soon as possible. Sometimes it is vital to show individuals that they are above or low of a specific value.
Joep Hoekstra commented
We really need conditional formatting per row in a Matrix Visual!!!!
Janine Xavier commented
Hi, can we please have this functionality where a user can change the formatting (change colour/bold/italics) a single row of choice in a Matrix visual. Conditional formatting as mentioned allows user to highlight rows based on values. But we require the ability to format a row of choice. Thank you
David Cresp commented
This is functionality that we really need soon. Please give some more votes to this great idea.
Needed as part of general 'parity with Excel formatting'. Please implement soon as data tables are currently a 'sea of numbers' if multiple metrics are needed in same table/matrix.