Skip to main content
Microsoft Idea

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

    David Proulx 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

    ewok 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

    Power BI User 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

    Samuel Adebayo 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

    Szymon Waszczyński 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

    Power BI User 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

    Power BI User 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

    Glen McGrath 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.

    's profile image Profile Picture

    subbarao on 06 Jul 2020 00:11:22

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is needed while creating financial reports .

    's profile image Profile Picture

    Eugenia Burleai on 06 Jul 2020 00:11:11

    RE: Conditional Formatting for Total and Subtotals in Matrices

    it is a big need for the financial report and general for reporting