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

    074a640a c0a0-4a21-9dca-16ab68154ca3 on 06 Jul 2020 00:10:11

    RE: Conditional Formatting for Total and Subtotals in Matrices

    please do make this happen

    's profile image Profile Picture

    5ed9ec32 a194-47f7-a175-f79ef5cda204 on 06 Jul 2020 00:10:09

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This functionality is REALLY needed

    's profile image Profile Picture

    60b14a02 5901-4252-a55e-2133f4440674 on 06 Jul 2020 00:10:05

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Definitely needed

    's profile image Profile Picture

    23eb3bf9 4b65-43a1-b784-1a1ad05809ed on 06 Jul 2020 00:09:58

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add - essential for a matrix with an overall result

    's profile image Profile Picture

    54854549 baa2-4f95-914e-4ec304f4a24c on 06 Jul 2020 00:09:56

    RE: Conditional Formatting for Total and Subtotals in Matrices

    PLEASE!!

    's profile image Profile Picture

    eea42023 c80b-4671-b11f-4308b25771c7 on 06 Jul 2020 00:09:52

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add this feature. It is essential.

    's profile image Profile Picture

    1fac0baf 9610-4152-8bad-924d339565a1 on 06 Jul 2020 00:09:52

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Hierarchical sorting needed in visuals ...
    Work around is add a numeric column to dummy up the sort. ie 3 tier sort the column would be nnn format where each position relates to each tier. Also need a way to hide this special sorting column
    Up vote this one too!
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue

    's profile image Profile Picture

    3ddf476b 9359-48c5-a4a3-c8c736eb4dcd on 06 Jul 2020 00:09:51

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Hello. This feature would add tremendous value to our organization. Would love to see it added! Thank you in advance.

    's profile image Profile Picture

    1b15f084 cafb-41f1-9427-bc7773aa8a3d on 06 Jul 2020 00:09:40

    RE: Conditional Formatting for Total and Subtotals in Matrices

    No update for more than a year for a feature request with ~ 5k votes, and the feature has been available in Excel for ages!! PBI team, you continue to amaze AND frustrate...

    's profile image Profile Picture

    6407ea81 3d16-4be9-8af8-06fba2221b4f on 06 Jul 2020 00:09:40

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is VERY much needed with options of having parent-row conditional formatting a deeper color and sub-rows/child-rows a more transparent color.