Forum Discussion

Jlbaenlo's avatar
Jlbaenlo
Frequent Visitor
3 years ago

PBI Waterfall based on measures with intermediate sum

Hi, maybe someone faced that problem.

I am trying to make a waterfall using measures on the x axis. I can do this using the trick explained here https://exceleratorbi.com.au/waterfall-charts-using-measures-power-bi/

but I would like then to have an intermediate sum, so a bar which starts from the bottom and then continue the waterfall.

for instance 

total sales F3 (bar starting from the bottom)

variance1 (bar starting from the top of the previous bar)

variance2 (bar starting from the top of previous bar)

total sales F0 (bar starting from the bottom, somehow an intermediate sum)

variance3 (bar starting from the top of the previous bar)

variance4 (bar starting from the top of the previous bar)

toral sales F1 (final bar starting from the bottom)

so if you like

Total sales F0 = Total Sales F3 + variance1 + variance2

Total Sales F1 = Total Sales F0 + variance3 + variance4

Is there a way to achieve this ?

many thanks in advance for your help !

Regards,

Jean-Luc

1 Reply

  • Hey Jlbaenlo ,

     

    an "intermediate result" is not possible with the default waterfall chart , but you can achieve this easily using the Zebra BI Charts" visual.

     

    Regards,

    Tom