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

    19b6ae63 2a87-420a-924c-36f82c792743 on 06 Jul 2020 00:08:36

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Calling out variance to target is a basic practise. therefore being able to apply conditional formatting to subtotals is very important

    's profile image Profile Picture

    dde26ac0 00ab-436c-b583-37134ff406f7 on 06 Jul 2020 00:08:32

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I need this feature Please!

    's profile image Profile Picture

    bacb52c0 f0e6-4989-9c31-97f157ec59dd on 06 Jul 2020 00:08:25

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Honestly some of this stuff is basic common sense , why wait for Votes for such add such a basic feature ?

    's profile image Profile Picture

    1db196f0 5d93-4dab-a1ef-5476f627a6a9 on 06 Jul 2020 00:08:03

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Looking forward to the July 2020 release. We need this when adding month-over-month variance analysis columns (e.g, ∆$, ∆qty, ∆%). Thanks.

    https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/conditional-formatting-totals-subtotals

    's profile image Profile Picture

    fdd6c11b e8db-45fa-8fca-2553bb19b3e5 on 06 Jul 2020 00:08:02

    RE: Conditional Formatting for Total and Subtotals in Matrices

    It's a pain to open all levels of a hierarchy to see the conditionally formatted cells on the lowest level.
    This extension of conditional formatting would be very helpful.

    's profile image Profile Picture

    3aa24738 6bbd-49c1-b2b1-6670b25477fd on 06 Jul 2020 00:07:57

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add this feature asap. Thanks

    's profile image Profile Picture

    9c05ec48 b201-4d77-9cec-437d07637239 on 06 Jul 2020 00:07:57

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This feature is highly needed in our organization

    's profile image Profile Picture

    0fd86f1d c6d8-4ef7-942a-649105657519 on 06 Jul 2020 00:07:53

    RE: Conditional Formatting for Total and Subtotals in Matrices

    C'mon Microsoft. These is very basic and a must. Having the rows formatted but not the totals just looks bad

    's profile image Profile Picture

    6bfef104 6978-46bc-9895-ac33d7c17f8d on 06 Jul 2020 00:07:53

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add this feature asap. Thanks.

    's profile image Profile Picture

    8cacc060 dd3a-406a-b030-bb6ae57768a3 on 06 Jul 2020 00:07:24

    RE: Conditional Formatting for Total and Subtotals in Matrices

    July 2020!
    https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/conditional-formatting-totals-subtotals