Skip to main content

Power BI

Needs Votes

Matrix: conditional formatting per row in matrix

Vote (242) Share
's profile image

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)
's profile image Profile Picture

d7b9c060 f53d-406c-a8db-a59544f6331a on 05 Jul 2020 23:17:27

RE: Matrix: conditional formatting per row in matrix

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.

's profile image Profile Picture

0e69546a 4a0e-4aef-b051-ec2e0f6dfa0a on 05 Jul 2020 23:15:49

RE: Matrix: conditional formatting per row in matrix

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.

's profile image Profile Picture

fce0565e 0cd0-485e-914b-a2c432b3d665 on 05 Jul 2020 23:13:49

RE: Matrix: conditional formatting per row in matrix

We really need conditional formatting per row in a Matrix Visual!!!!

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:12:36

RE: Matrix: conditional formatting per row in matrix

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

's profile image Profile Picture

4e2ed990 e62a-4956-94cf-e2ae7078a9e9 on 05 Jul 2020 23:07:54

RE: Matrix: conditional formatting per row in matrix

This is functionality that we really need soon. Please give some more votes to this great idea.

's profile image Profile Picture

f9460a9f a38d-4368-b28f-af80c5491acb on 05 Jul 2020 23:07:25

RE: Matrix: conditional formatting per row in matrix

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.