Forum Discussion

aredmond127's avatar
aredmond127
Frequent Visitor
4 years ago

Waterfall Chart Help

Hi - totally new to Power BI and need help on waterfall chart please.   I need to show Baseline to Total Saleable, with event type as the breakdown (Baseline + Event = Total Saleable). My data is i...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi aredmond127 ,

 

Depending on your needs, a separate column needs to be created to count the values of the baseline + events. Then put it in the waterfull chart visual values. The reference is as follows:

Col_total =
CALCULATE (
    SUM ( 'Table'[Value] ),
    ALLEXCEPT (
        'Table',
        'Table'[Region],
        'Table'[Division],
        'Table'[Major Category]
    )
)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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

aredmond127's avatar
aredmond127
Frequent Visitor
4 years ago

Hi Henry, 

 

Thanks for  the above help - however it's not quite right. Below is the result I'm getting, where baseline = total saleable, with no events values in between. 

 

To clarify, the graph should show baseline on the left, with events as the breakdown and total saleable on the right hand side. For example,

 

Baseline = 10 

Event 1 = 2

Event 2 = 5 

Event 3 = -3

Total Saleable = 14

 

 

 

To provide clarification, please see total example below. I've trimmed down the data set but there would be >1M rows of data, multiple divisions, regions, major categories etc. plus multiple other columns not included, that could act as further filters. 

 

From the data, I need to show the waterfall in the below format. The number of filters applied and combination of filters is user determined and could be any number of options (further examples below).

 

Hope this makes sense - thanks again for the help.