Forum Discussion
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
- TomMartens
Super User
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