Skip to main content

    Power BI

    Merged

    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 18 Oct 2024 21:19:06

    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.

    Merged with Epic idea: Custom totals for tabular visuals
    Comments (76)
    '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

    Andrea on 06 Jul 2020 00:10:46

    RE: Conditional Formatting for Total and Subtotals in Matrices

    when will this feature be implemented?

    's profile image Profile Picture

    C M 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

    Yi-jing Chung on 06 Jul 2020 00:08:57

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Please add this !

    's profile image Profile Picture

    Jour on 06 Jul 2020 00:06:54

    RE: Conditional Formatting for Total and Subtotals in Matrices

    '+1

    's profile image Profile Picture

    Phong Nguyen on 06 Jul 2020 00:05:57

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Oh man, the idea was raised from 2016 Dec and it's still not available :(

    's profile image Profile Picture

    Leslie Rotella on 06 Jul 2020 00:05:49

    RE: Conditional Formatting for Total and Subtotals in Matrices

    This is still very necessary! Please implement!

    's profile image Profile Picture

    Toby Lupton on 06 Jul 2020 00:05:24

    RE: Conditional Formatting for Total and Subtotals in Matrices

    Seems to be a common theme here for the want to apply simple formatting to data tables so that the visuals are consistent throughout. For me and my company, a small thing like this is likely to be a deal breaker when deciding to opt to switching from Excel/PowerPoint to Power BI as a reporting tool.

    's profile image Profile Picture

    Aleh Kalinichau on 06 Jul 2020 00:05:17

    RE: Conditional Formatting for Total and Subtotals in Matrices

    5,109 votes and this isn’t (yet!) on our near term roadmap.
    Magic! No comments.

    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:04:37

    RE: Conditional Formatting for Total and Subtotals in Matrices

    DOODS ITS ABOUT TIME