Skip to main content
Microsoft Idea

Power BI

Completed

Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

Vote (27) Share
's profile image

on 02 Sep 2016 10:53:10

Be able to conditional format values in the matrix visual and also be able to heatmap within the columns of matrix visual

Administrator on 25 Apr 2017 03:22:38

Hi y'all, We added conditional formatting for the matrix visual back in November. You can learn about the feature here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#matrixConditionalFormatting And for those using our new matrix preview, you'll be able to use the same functionality there. - Amanda

Comments (6)
's profile image Profile Picture

Power BI User on 05 Jul 2020 22:51:08

RE: Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

The conditionnal formatting currently added lacks flexibility. You should be able to specify on which kind of grouping you want the conditionnal formatting to apply. I have to go back to Excel with a Pivot Table to have conditionnal formatting by column instead of the whole matrix. Sad!

's profile image Profile Picture

Ananth on 05 Jul 2020 22:35:24

RE: Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

'+1

's profile image Profile Picture

Ali KhoshgoftarMonfared on 05 Jul 2020 22:33:05

RE: Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

I would also suggest to allow tooltips as an alternative for tables and later matrices in the case of conditional formatting. While it is good that we can show the value of every cell, tooltips can be more helpful in the case of very large matrices and tables.

's profile image Profile Picture

Power BI User on 05 Jul 2020 22:32:37

RE: Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

Agreed, conditional formatting on the matrix would be awesome.

's profile image Profile Picture

Anthony Newell on 05 Jul 2020 22:31:30

RE: Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

Yes please, come across a need for it now!

's profile image Profile Picture

Balu on 05 Jul 2020 22:30:07

RE: Conditional Formatting & Heat Map functionality in the "Matrix" visualisation

Hi Power Bi team - When can we expect conditional formatting for matrix/matrices? I know we have it for tables. It would be great if we can have it for matrix/matrices as well.