Mix Variance & Waterfall graph


Is there any way to create a waterfall graph from a stacked column visual where the variances (volume, price, mix, fx impact, etc.) are based on measures?


I’m sure you could do this in some way.

You would probably need to create a brand new table though that summarize all your data by day, but then had all those variances differences laid out entirely for every day.

So for each day you might have 5 rows, with volume, price,…variances for each.

Then you could use this to bring into a visualize quite easily.

So the hard part would be getting this new table setup based on you current calculations.


1 Like

Hi @mv914, we’ve noticed that no response has been received from you since February 03, 2020. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!