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 (547)
's profile image Profile Picture

7e58af98 27af-40a0-a2ea-7ab7e9608cd3 on 05 Jul 2020 23:15:33

RE: Conditional Formatting for Total and Subtotals in Matrices

It is very important !

's profile image Profile Picture

9510b157 ddb4-48e8-ab44-2c3d8b347691 on 05 Jul 2020 23:13:49

RE: Conditional Formatting for Total and Subtotals in Matrices

The conditional formatting on the rows within the matrix is great, but without having the same formatting on totals and subtotals, the visual is incomplete. Please add this feature!

's profile image Profile Picture

52cae758 e44d-4cad-b701-db25cbe25133 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

ccdad9b8 3b62-4273-9a6c-93b824bc38f9 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

c64e0ab5 7cbe-42b4-9221-c00fefeee99e 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

74d29735 e899-45d9-a541-0fc8ebc5f6df 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

6aaf2d49 0200-47d7-adf1-fcd3c1e42275 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

18aa1c62 e6f8-4e91-8202-fe37d7822181 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

77e5bff4 aa23-41f8-84b1-58be8ca02d22 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

e897f495 cbb4-4454-a34f-65033829b182 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.