Skip to main content
Microsoft Idea

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

Power BI User 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

Noxy 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

Bechir Nahali 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

Lasse Matthias 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

Dávid Bessenyei 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

Power BI User 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

Akansha 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

Rushil Dajee on 05 Jul 2020 23:03:57

RE: conditional formatting in matrix

Need for text, dates etc.

EYMARD's profile image Profile Picture

Power BI User 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

Scott A on 05 Jul 2020 22:59:29

RE: conditional formatting in matrix

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