Skip to main content

Power BI

Completed

conditional formatting in matrix

Vote (247) Share
EYMARD's profile image

EYMARD on 21 Jul 2016 20:57:13

I need to have the possibility to add conditional formatting in Matrix chart as we can do in Cross table in Excel.
Thanks

Administrator on 29 Nov 2016 04:19:05

We've added support for conditional formatting on the matrix visual in the November release of Power BI Desktop. To learn more, check out our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/

Comments (38)
EYMARD's profile image Profile Picture

Christian on 05 Jul 2020 22:35:01

RE: conditional formatting in matrix

I need to have the chance to add conditional formatting in a Matrix

EYMARD's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:43

RE: conditional formatting in matrix

As a recent switcher from tableau I'm finding BI's inability to do some pretty basic stuff pretty frustrating...

EYMARD's profile image Profile Picture

German Henriquez on 05 Jul 2020 22:33:53

RE: conditional formatting in matrix

Excellent, this feature is coming¡¡¡

EYMARD's profile image Profile Picture

Frank Thomson on 05 Jul 2020 22:33:51

RE: conditional formatting in matrix

We are waiting for this too, would be a nice feature for the december release:).

EYMARD's profile image Profile Picture

Herman on 05 Jul 2020 22:33:38

RE: conditional formatting in matrix

Any feedback on when will this be available ?

EYMARD's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:33:22

RE: conditional formatting in matrix

This would be a great addition

EYMARD's profile image Profile Picture

David Gulli on 05 Jul 2020 22:33:12

RE: conditional formatting in matrix

yep i agree - silly that this isnt already a thing!

EYMARD's profile image Profile Picture

plaidDK on 05 Jul 2020 22:32:36

RE: conditional formatting in matrix

Could you please add conditional formatting on non measures? There is no possibility to make conditional format like if then else.

Ex. i have a dashboard monitor over SQL job agent. I want to conditional format if success then green if failure then red else yellow..

EYMARD's profile image Profile Picture

Nagaraju on 05 Jul 2020 22:32:28

RE: conditional formatting in matrix

I have same requirement, We need conditional color formatting based on two fields(Start Date and End Date columns) but to be applied on entire ROW in table. If the difference between Start date and End date more than 1 days, entire the ROW should display in red color else should display ROW in white background color.

EYMARD's profile image Profile Picture

Ali KhoshgoftarMonfared on 05 Jul 2020 22:32:11

RE: conditional formatting in matrix

Thanks,
One more suggestions / ask for the matrix and table visual is to allow them to act as filters, similar to what for example a tree map does.
It will be great to see a matrix visual with conditional formatting that can also act as a 2-D filter. E.g. when you select a cell, the category for the row and column in other charts are cross filtered as well.