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.

5,027 votes
Sign in
(thinking…)
Sign in with: Facebook Google
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 →
backlog  ·  Amanda Cofsky responded  · 

Thanks for the feedback! While this isn’t (yet!) on our near term roadmap, please keep voting and giving us feedback on the idea. We definitely see the need and will update the idea when we are closer to adding this feature.

525 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    This is a big need for any financial department. It is important to show red negatives in matrices in order to make the important numbers stand out. The conditional formatting to display negative numbers in red is useless if I cannot do the same for the subtotals and grand total numbers.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I know this issue seems minor to MS, but matrices with conditional formating, while not sexy, are widely used. and the conditional formatting missing from subtotals is the first thing the users notice when using our reports
    Also, don't forget to add a switch to turn off Grand Totals separately from Subtotals. And please add set column widths.
    Thanks.

  • claire commented  ·   ·  Flag as inappropriate

    would love to see this implemented as quickly as possible, we have a number of power bi users at bluescope and for reporting purposes will make the visuals tell the story more quickly

  • Anonymous commented  ·   ·  Flag as inappropriate

    Hello Power BI team,

    I'm really sad that is is still in backlog and has been for over a year. Business users are really requesting this often.

  • Rafael Mafra commented  ·   ·  Flag as inappropriate

    We need it urgently!
    A possible alternative would be to create a dax function that returns RGB Collor formatting

  • Gary Thomann commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • Casandra commented  ·   ·  Flag as inappropriate

    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.

  • Richard Oliver commented  ·   ·  Flag as inappropriate

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

← Previous 1 3 4 5 … 26 27

Power BI Ideas: Custom Visuals

Categories

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.