Forum Discussion
Waterfall variation by sales type
Thank you for your response. Here's a picture of what I've trying to achieve in Power BI. As you can see, it's possible in Excel with some data manipulation:
Essentially, I want the first column to be 2015 total and the last column to be 2016 total. The columns in-between should be the variance by category.
I can't find a way of implementing this Power BI. I hope you guys can help.
Super UserHi goyasor,
I have made something similar to a post a few months ago, please check it out and if you have any questions please tell me.
The final result was the one show below, this example is with periods but can be change to Manufacturer.
Regards,
MFelix
Thanks for your response. Unfortunately that didn't work for me.
I'm getting a constant figure in the Periods column:
- MFelix
Be aware that this is a measure an not a calculated column that I use to show the percentages.
If you can share some data I can try to simulate and redefine the formula.
MFelix
Here's the raw data I used in Excel:
Manufactuter Category 2015 Sales 2016 Sales Variance 2015-16 GM Country A 1,000,000 2,000,000 1,000,000 GM Country B 1,000,000 2,400,000 1,400,000 Ford Country A 3,000,000 1,900,000 -1,100,000 Ford Country B 4,000,000 3,000,000 -1,000,000 Toyota Country A 1,000,000 2,000,000 1,000,000 Toyota Country B 3,000,000 3,800,000 800,000 Honda Country A 2,000,000 1,000,000 -1,000,000 Honda Country B 2,500,000 2,000,000 -500,000 Chrysler Country A 500,000 900,000 400,000 Chrysler Country B 1,000,000 2,000,000 1,000,000 TOTAL 19,000,000 21,000,000 I used it to create this summary table (also in Excel):
2015 Sales 19,000,000 GM 2,400,000 Ford -2,100,000 Toyota 1,800,000 Honda -1,500,000 Chrysler 1,400,000 2016 Sales 21,000,000 Then finally the Waterfall chart: