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

06104f85 a912-4356-acc1-c47a37386f8c on 06 Jul 2020 00:02:25

RE: Conditional Formatting for Total and Subtotals in Matrices

Why is this in backlog for years and not getting any movement even though it has considerable votes?
We need this feature

's profile image Profile Picture

9fff00f5 740e-4463-9490-ac390d7c2ecc on 06 Jul 2020 00:02:25

RE: Conditional Formatting for Total and Subtotals in Matrices

Please apply the conditional formatting to the higher level of data even though I drill down to the lower level in Matrix

's profile image Profile Picture

a9fe826b 0bf4-4f54-90cf-431e9ed27297 on 06 Jul 2020 00:02:23

RE: Conditional Formatting for Total and Subtotals in Matrices

This needs to be fixed, why would you not apply the same conditional formatting to totals and subtotals

's profile image Profile Picture

246afe12 bc8b-4abb-99dc-5733896e08b5 on 06 Jul 2020 00:02:22

RE: Conditional Formatting for Total and Subtotals in Matrices

Come on guys, cringing when I'm presenting reports and having to explain this

's profile image Profile Picture

5a7e7b0a 100c-46ad-a629-c63bddc02775 on 06 Jul 2020 00:02:21

RE: Conditional Formatting for Total and Subtotals in Matrices

The customer is looking to have the conditional formatting the same as in the column for subtotals and totals as well and they are not ready to digest it that it is not provided in the tool so far.

's profile image Profile Picture

b2b9291b 96ee-4d52-8079-fa49c2c6f1a8 on 06 Jul 2020 00:02:18

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a huge issue right now, I'm not able to explain to business users why the conditional formatting is not working for row totals in matrix. Is there any way to expedit this? It can't be a huge change.

's profile image Profile Picture

a3998d99 1562-47db-8aa2-3888bc34ce78 on 06 Jul 2020 00:02:18

RE: Conditional Formatting for Total and Subtotals in Matrices

Why was this not default from the beginning? A simple slider to turn off and you cover everyone's needs. What a huge miss! This prevents use from transitioning Executive level reporting to PBI :(:(

's profile image Profile Picture

c0a7d187 8d1c-416e-83ee-cd8e3acfa3f9 on 06 Jul 2020 00:02:17

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a must have - can't believe its not on a priority list

's profile image Profile Picture

327dc23e c430-4b69-93ac-68a058982f88 on 06 Jul 2020 00:02:15

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a huge disappointment for our users who we just moved over from a competing BI product.

's profile image Profile Picture

67ec52a1 e4fe-4360-8561-2b7bfc12714d on 06 Jul 2020 00:02:14

RE: Conditional Formatting for Total and Subtotals in Matrices

Let's implement this. Please