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

10deda8d 1e14-4da4-9610-76bcd141aa05 on 06 Jul 2020 00:04:45

RE: conditional formatting in matrix

Please provide an option to color the positive numbers to green color and negative numbers to red color in Power BI table

EYMARD's profile image Profile Picture

ec3961b2 dc25-4b68-aaca-0dcae3c741a4 on 06 Jul 2020 00:01:00

RE: conditional formatting in matrix

can you please try to mimic excel when it comes to the conditional formatting, I want to be able to add negative numbers.

EYMARD's profile image Profile Picture

66938bee 228b-4762-bb60-39b954b76532 on 05 Jul 2020 23:56:05

RE: conditional formatting in matrix

I totally agree some values need to be highlighted compared to others (negativ ones for example)

EYMARD's profile image Profile Picture

a8cc4593 cdc0-48f5-9742-a1d52206a459 on 05 Jul 2020 23:48:03

RE: conditional formatting 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!

EYMARD's profile image Profile Picture

e96e98f7 c252-4ee9-bed0-7e8be78f4c71 on 05 Jul 2020 23:42:02

RE: conditional formatting in matrix

Please add the ability to conditionally format the row headers.
Sometimes I have a chart and a matrix with the same data categories on a page. It would be great to use the same color for these categories.

The matrix could also function as a legend for the chart.
I use the table visual for this use-case, but sometimes the matrix would be better.

EYMARD's profile image Profile Picture

c686b006 5618-4b7b-afb7-6668bc9813ed on 05 Jul 2020 23:39:29

RE: conditional formatting in matrix

the conditional formatting that has been applied is at the detail not the subtotal and total values, here is still a way to go on this area personally !

EYMARD's profile image Profile Picture

a3d9871d 1a97-45dc-942e-c916d1ca4130 on 05 Jul 2020 23:19:28

RE: conditional formatting in matrix

In a matrix visual, conditional formatting is available for fields under "Values" only. i want to color code the fields in "Rows" too. This is especially useful after the May 2018 release where we can conditionally format any field present in the data model and not just the visual fields. Please add that.

EYMARD's profile image Profile Picture

8ff1ed7a 48c6-4c1a-a618-25bd30e036c5 on 05 Jul 2020 23:03:57

RE: conditional formatting in matrix

Need for text, dates etc.

EYMARD's profile image Profile Picture

5e691a51 0ae5-4386-89ea-bdb92d05a686 on 05 Jul 2020 23:03:01

RE: conditional formatting in matrix

Need different colors for each data bar...

EYMARD's profile image Profile Picture

15edc63c 64a0-418a-8b78-92bc4937edb7 on 05 Jul 2020 22:59:29

RE: conditional formatting in matrix

This feature is incomplete. Need conditional formatting on text, dates, etc...