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

    Rob Power BI User on 06 Jul 2020 00:10:05

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Definitely needed

    's profile image Profile Picture

    Paula 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

    Power BI User on 06 Jul 2020 00:09:56

    RE: Conditional Formatting for Total and Subtotals in Matrices

    PLEASE!!

    's profile image Profile Picture

    M 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

    Gary Thomann 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

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

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

    Casandra 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.

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:09:38

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This challenges formatting for $values in financial reports....

    's profile image Profile Picture

    Richard Oliver on 06 Jul 2020 00:09:37

    RE: Conditional Formatting for Total and Subtotals in Matrices

    I would like to see this, so we can compare the grand totals to the RAG rating (for example) of the rows above.