Skip to main content

Power BI

Completed

Conditional Formatting for Total and Subtotals in Matrices

Vote (5185) Share
's profile image

on 12 Dec 2016 08:57:40

The recent addition of conditional formatting for values is wonderful. However, it would be great to have the ability format subtotals and totals, as the variation on those fields are often even more important to draw attention to.

Administrator on 23 May 2020 01:39:28

Thanks everyone for your votes on this feature! With the April 2020 release of Power BI Desktop this is now available! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Conditional_formatting Please keep commenting on this feature with other feedback, we check the Completed items as well as ones that are still active.

Comments (555)
's profile image Profile Picture

Muzaffer on 05 Jul 2020 23:13:36

RE: Conditional Formatting for Total and Subtotals in Matrices

I need this feature to show region and subregion totals and subtotals

's profile image Profile Picture

Nick on 05 Jul 2020 23:13:17

RE: Conditional Formatting for Total and Subtotals in Matrices

I am desperately needs this feature for our finance department

's profile image Profile Picture

Javier Buendía Carrera on 05 Jul 2020 23:13:07

RE: Conditional Formatting for Total and Subtotals in Matrices

I agree with this improvement. When you have a matrix when you need extra levels of information, you need to apply the correct conditional formatting for all data.

's profile image Profile Picture

Sasha Marsee Holder on 05 Jul 2020 23:12:54

RE: Conditional Formatting for Total and Subtotals in Matrices

I agree. This makes me look bad presenting all negative numbers in red, but the results are not in red!

's profile image Profile Picture

AnilP on 05 Jul 2020 23:12:44

RE: Conditional Formatting for Total and Subtotals in Matrices

This has to be enabled as it doesn't make any sense having it for the rows and columns but not to the totals & Subtotals

's profile image Profile Picture

Rebecca H on 05 Jul 2020 23:12:42

RE: Conditional Formatting for Total and Subtotals in Matrices

It looks so odd having the values and not the totals conditionally formatted. Please can this be added! Thanks.

's profile image Profile Picture

Lim Soon on 05 Jul 2020 23:12:13

RE: Conditional Formatting for Total and Subtotals in Matrices

Please provide this feature. Thanks!

's profile image Profile Picture

Walter Suarez on 05 Jul 2020 23:12:11

RE: Conditional Formatting for Total and Subtotals in Matrices

Really it something basic for our presentations, as said below, sometimes the subtotal are as important (or even more) than detailed rows.

's profile image Profile Picture

James Symcox on 05 Jul 2020 23:10:57

RE: Conditional Formatting for Total and Subtotals in Matrices

This feature would be beneficial to myself. I've voted with the other 155 people, can this be developed for the next release?

's profile image Profile Picture

ESMO on 05 Jul 2020 23:10:50

RE: Conditional Formatting for Total and Subtotals in Matrices

QlikView is able to do this basic feature for years!
Can't believe this is not possible with PowerPI!