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

012292e2 2cf6-4e5d-a627-1f35f635f976 on 05 Jul 2020 23:24:20

RE: Conditional Formatting for Total and Subtotals in Matrices

Could you at the very least add a slider in the Conditional formatting menu to 'format subtotal'? That way we can at least have the entire value formatted the same if a separate format for the subtotal is a complicated job.

's profile image Profile Picture

7214f99b 7ea1-475e-bafb-183ff1a01e3a on 05 Jul 2020 23:24:07

RE: Conditional Formatting for Total and Subtotals in Matrices

We need it!!

's profile image Profile Picture

3c80b9d9 c720-4382-b06e-705476fdb6e0 on 05 Jul 2020 23:23:44

RE: Conditional Formatting for Total and Subtotals in Matrices

It is obvious that this should be a part of the conditional formatting

's profile image Profile Picture

5ff10f4f 37f5-4867-8a2b-b738f69bc2bd on 05 Jul 2020 23:23:31

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a critical item. The conditional formatting in matrix and tables is not acceptable in current state.

's profile image Profile Picture

ab3ca152 4f3e-42e5-b00d-5cf5cc3340b1 on 05 Jul 2020 23:23:30

RE: Conditional Formatting for Total and Subtotals in Matrices

Must be added, major limitation for ensuring impact with users

's profile image Profile Picture

911fca1b ce77-4f29-bfb2-777cd480c0f3 on 05 Jul 2020 23:23:18

RE: Conditional Formatting for Total and Subtotals in Matrices

Very important add for our dashboards

's profile image Profile Picture

f3450c0a 02da-4fed-a19b-9fd3b490584b on 05 Jul 2020 23:23:03

RE: Conditional Formatting for Total and Subtotals in Matrices

I need it too, this is important as totals are the main drivers

's profile image Profile Picture

e976086e 7521-4bdd-b081-150f8f17d11e on 05 Jul 2020 23:22:47

RE: Conditional Formatting for Total and Subtotals in Matrices

Still waiting for this implementation !!

If you were using Power BI for your own monitoring you would have notice it's a must have !! Hurry up please

's profile image Profile Picture

2452a32a 2b6a-46c1-9a80-c4b12f257278 on 05 Jul 2020 23:22:46

RE: Conditional Formatting for Total and Subtotals in Matrices

It's quite frankly ridiculous this is not available yet

's profile image Profile Picture

1c1f9e51 5742-4fcd-bb43-211d3ee8d05f on 05 Jul 2020 23:22:44

RE: Conditional Formatting for Total and Subtotals in Matrices

It's a must. All accountants are complaining about this.....