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

5e1242c3 4a76-400f-893c-c2c701ea34d7 on 06 Jul 2020 00:12:55

RE: Conditional Formatting for Total and Subtotals in Matrices

This is a must have. Have no idea how this is still not included by default.

's profile image Profile Picture

c8433e16 4d3d-4518-b849-9104adc437c2 on 06 Jul 2020 00:12:48

RE: Conditional Formatting for Total and Subtotals in Matrices

Much needed!

's profile image Profile Picture

7f64d156 3c44-4560-b3e3-0ec5f8fc9475 on 06 Jul 2020 00:12:21

RE: Conditional Formatting for Total and Subtotals in Matrices

This shouldn't even be a "feature"... this is basic common sense that we need these formatting to be able to cascade up or down in relationship with context.

This is exactly with these kind of unexpected fails / missing pieces that convincing a large organization to move from other platforms towards PowerBI is difficult to accomplish...

's profile image Profile Picture

0df6158f 3118-402b-a6cd-b66b18940702 on 06 Jul 2020 00:12:11

RE: Conditional Formatting for Total and Subtotals in Matrices

"While this isn’t (yet!) on our near term roadmap"...

So it is not even on the road map at all?

's profile image Profile Picture

2aeb5904 e3bc-4040-beb3-9861a49383b0 on 06 Jul 2020 00:12:01

RE: Conditional Formatting for Total and Subtotals in Matrices

Essential with out an alternative.

's profile image Profile Picture

cb44e704 0e7d-46f8-97e4-9379139d9a41 on 06 Jul 2020 00:11:58

RE: Conditional Formatting for Total and Subtotals in Matrices

This will be really helpful

's profile image Profile Picture

08d09ba8 6ab0-41b8-8b27-fdacd613cdb2 on 06 Jul 2020 00:11:41

RE: Conditional Formatting for Total and Subtotals in Matrices

Looking forward to see this feature. It will improve the transparency for table users especially while looking on complex financial data sets

's profile image Profile Picture

a9a73f81 bcaf-437f-bfa8-eeec00c8670b on 06 Jul 2020 00:11:30

RE: Conditional Formatting for Total and Subtotals in Matrices

This would be incredibly helpful

's profile image Profile Picture

1c04421a a727-4714-bbf6-aa81ca2e6186 on 06 Jul 2020 00:11:25

RE: Conditional Formatting for Total and Subtotals in Matrices

This is definitely needed. Please bring that feature

's profile image Profile Picture

d5dfb665 64bb-470b-8c49-14a0cb7e390f on 06 Jul 2020 00:11:22

RE: Conditional Formatting for Total and Subtotals in Matrices

This is definitely needed for financial reports. Please implement.