Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Total Column Conditional Formatting on Waterfall chart

This is my first ever post on forum (so bear with me), I have noticed this topic has appeared a few times in these forums, this is regarding conditional formatting of the 'Total' column in a waterfall chart (or lack of). Like other people, I'm having issues with the 'Total' column not formatting properly (I've set any values less than zero to be red) but I've noticed that when negative values appear on the graph it turns the Total (which is positive) red as well.

FrankieBhoy_0-1731514972462.png

 

With no negatives 

FrankieBhoy_1-1731515052197.png

Is this a glitch? If not, why does it do this?

Status: Investigating

Hi @FrankieBhoy ,

 

Based on the above information, It's a reproducible issue. I would suggest opening a Support Ticket.

If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @FrankieBhoy ,

 

Based on the above information, It's a reproducible issue. I would suggest opening a Support Ticket.

If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you. 
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

 

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

FrankieBhoy
New Member

Hi,

 

Thank you for your response, I've opened a support ticket.

I've done some further investigating and I've noticed that it seems that the conditiional formatting of the column to the left of the 'Total' dictates the conditional formatting colour of the 'Total' value (which clearly shouldn't be the case).

 

I will provide an update on this.

FrankieBhoy
New Member

Update:
Support suggested that I submit an idea for conditional formatting of Total columns option to be added to charts (the same as tables).