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.

3,383 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  ·  AdminAmanda Cofsky (Program Manager, Microsoft Power BI) 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.

349 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

    Much needed. I'm surprised it has not been completed already. Power BI needs to concentrate on the current features while advancing. Not just work on new features.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Difficult to believe this request is now nearly 3 years old. Please make this happen.

  • Anonymous commented  ·   ·  Flag as inappropriate

    really need this for resource reports, where the individual lines don't show as overloaded, but the summary should

  • Anonymous commented  ·   ·  Flag as inappropriate

    Power BI looks like a poor BI tool to management when we put out a report without basic functionality that all other BI tools have. Missing basic features like this is making it very difficult to sell Power BI to our management.

  • Jose Gonzalez commented  ·   ·  Flag as inappropriate

    This feature is needed. For example in the case that you have a matrix with values of different currencies, and you want to put a column for the currency, you don't have a way to take out the value in the total row for that column that is text.

  • YJ commented  ·   ·  Flag as inappropriate

    In most cases the "Total" line is the one that bring the most value. This feature should be there to allow it to stand out better.

  • Adam K commented  ·   ·  Flag as inappropriate

    This is very basic functionality from Excel and desperately needed.

    Please, Power BI team, stop adding fancy bells and whistles on top of a crumbling foundation. You need to get the basics figured out first.

    My organization is filled with heavy Excel users, and it's impossible to get them to take Power BI seriously when it's lacking basic functionality like this.

  • Leo commented  ·   ·  Flag as inappropriate

    WE. NEED. THIS. In excel it was very easy to tell what was negative/decreased (RED) and what was positive/increased (BLACK), for both normal data AND the total rows/columns. How is this simple feature still not implemented two and a half years later...???!?!?!?!

  • Julian Silverthorne commented  ·   ·  Flag as inappropriate

    The new conditional formatting is a much-needed feature, so thanks for providing it. What would be really useful however is to be able to specify if the formatting should be applied to just the lowest level of data displayed (in hierarchy terms), or only to the subtotals, or all.

← Previous 1 3 4 5 … 17 18

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.