Forum Discussion

Ric_A's avatar
Ric_A
New Member
2 years ago
Solved

Waterfall Chart - Fixed Columns

Hi Everyone,

 

I have built a Waterfall chart in PowerBI, and I'm struggling with the following: I'm trying to compare, for instance, the current forecast against Budget. I know there are 2 ways of building the waterfall chart: fixed attributes or dynamic. In my case, it needs to be dynamic, because the idea is show the top10 customer driving the higher variations (and "others"). The issue that I'm facing is that, depending if Forecast > Budget, or Budget > Forecast, and as I'm sorting as decending or ascending, it changes the Current FC and Budget colums to the right or left. Is it possible to fix the Current FC column at the right side of the chart? Changing the way that the waterfall is built, it shows a different calculation because the order is backwards.

 

Here's an example:

 

 

The Current FC bar should be on the right. The way it is right now, the measures by customers are backwards (should be negative, not positive, etc).

 

Thank you in advance for helping me with this.

 

Best regards

RA

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ric_A ,

    In Power BI, the Waterfall chart's behavior is designed to show a running total as values are added or subtracted, which inherently makes the positioning of the columns dependent on the data's sorting order.

     

    I ahve also found a similar post, please refer to.

    Solved: Custom Sorting in the waterfall chart - Microsoft Fabric Community

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

     

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.