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

1f548b2c 85db-4343-ba8a-a59ac9a46103 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

a9a2764a 0122-49e8-ac74-da030585a97f 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

a9c38bb7 decf-49b7-a693-4826b0645c9c on 05 Jul 2020 22:33:53

RE: conditional formatting in matrix

Excellent, this feature is coming¡¡¡

EYMARD's profile image Profile Picture

507cf08d 94de-4a7a-9314-67581767297d 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

f69ade77 68f6-45ca-98bc-14b3729f03c1 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

4ef379c6 c03e-443c-8150-e73bd00593ab on 05 Jul 2020 22:33:22

RE: conditional formatting in matrix

This would be a great addition

EYMARD's profile image Profile Picture

3bab7d74 3189-405a-afdb-07461723f412 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

00eb054c 6eb5-4e8c-81d5-6842648c5ebf 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

ae61239f 0eee-47cf-af84-758475ab7784 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.