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

acb7fa47 070f-4df9-9327-40d3aa65639d on 06 Jul 2020 00:07:20

RE: Conditional Formatting for Total and Subtotals in Matrices

Basic functionality, would be nice to have it sooner than later.

's profile image Profile Picture

e9f0a974 80d9-428b-aae6-cd7c2ef3e9e8 on 06 Jul 2020 00:07:02

RE: Conditional Formatting for Total and Subtotals in Matrices

This is very basic feature we should have in Power BI. When customer wants to see performance of the product & subcategory of that product, It is very likely that customer would like to see performance at product level & then at subcategory level.

's profile image Profile Picture

e103fa91 792b-4049-8679-6c670499e926 on 06 Jul 2020 00:07:01

RE: Conditional Formatting for Total and Subtotals in Matrices

4 years and it's still not on the roadmap???

's profile image Profile Picture

209f1728 9199-4eed-b459-d112fd433ae0 on 06 Jul 2020 00:06:55

RE: Conditional Formatting for Total and Subtotals in Matrices

Also, conditional formatting of the row headers would be a huge improvement!!!

's profile image Profile Picture

df9eac80 f637-4799-8576-17ffbcea3feb on 06 Jul 2020 00:06:55

RE: Conditional Formatting for Total and Subtotals in Matrices

Please, please add this in. Also, conditional formatting for matrix row header values would be super useful. So, for example, the word 'Total' in the row header can be given another colour and then the conditional formatting can work on the total row to give the same colour. Don't let me down Microsoft :)

's profile image Profile Picture

9fef22d6 bb61-4882-904f-7890df7c859d on 06 Jul 2020 00:06:54

RE: Conditional Formatting for Total and Subtotals in Matrices

'+1

's profile image Profile Picture

56921391 e1e0-4578-b63a-566d04f87f8d on 06 Jul 2020 00:06:41

RE: Conditional Formatting for Total and Subtotals in Matrices

'+1

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:06:38

RE: Conditional Formatting for Total and Subtotals in Matrices

'+1

's profile image Profile Picture

db7e2076 c3b3-497c-b1d9-56061a06dc51 on 06 Jul 2020 00:06:31

RE: Conditional Formatting for Total and Subtotals in Matrices

NEEDS TO HAPPEN

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:06:30

RE: Conditional Formatting for Total and Subtotals in Matrices

NEEDS TO HAPPEN +1