How can we improve Power BI?

← Power BI Ideas

Conditional Formatting for Total and Subtotals in Matrices

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.

1,288 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    164 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        We need this functionality, it ruins the whole concept of a dashboard when you realize you don't have an option for color coding subtotals and totals, why limit? If you don't want color coding for totals then enable on and off, other tools has it and is a decision point to go to another tool when people realize is not possible.

      • anonymous commented  ·   ·  Flag as inappropriate

        It is crazy that you need to go to the lowest level of data to see conditional color formatting. We need to see RED for ANY negative values (including subtotals). If you can't look at aggregated data, what is the point of visualizations and summarized reporting? This is a serious gap- all other reporting tools we work with have this. Any number or field regardless of whether it is a subtotal should be able to have conditional formatting.

      • Steve Bedford commented  ·   ·  Flag as inappropriate

        The lack of this formatting causes no end of confusion, e.g. red when below zero on the rows but the black - but still below zero - at the subtotal level. It really needs sorting.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Yes this is a must please! I need this for a matrix calculating deltas and it doesn't look great when the values have conditional formatting but the subtotals/totals do not...

      • Jacky commented  ·   ·  Flag as inappropriate

        PBI team, pls it's basic element for conditional formatting....

      • Leonardo Ferreira da Silva commented  ·   ·  Flag as inappropriate

        This functionality is very basic so it does not exist in Power BI. Since in Excel there are several possibilities for conditional formatting in Totals, Subtotals and other cells.

      • Anonymous commented  ·   ·  Flag as inappropriate

        So many situations where there are no rows or columns but only totals. Please add this feature!

      • Anonymous commented  ·   ·  Flag as inappropriate

        This Feature is very necessary, please consider incorporating this. Thank you!

      • Nerys commented  ·   ·  Flag as inappropriate

        Yes please, I currently have to export info from PowerBi to excel for a particular weekly report to get around this problem

      • Anonymous commented  ·   ·  Flag as inappropriate

        Formatting to extend to the totals is a 'must have', makes the report look incomplete and i'm constantly explaining why

      • Anonymous commented  ·   ·  Flag as inappropriate

        I find that this is even more important now that the plus minus matrix buttons exist.

      ← Previous 1 3 4 5 … 8 9

      Power BI Ideas: Custom Visuals

      Feedback and Knowledge Base

      (thinking…)

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.