Forum Discussion
Need Assistance with Waterfall Chart
Hi CJS1199
You can refer to the following solution.
1.You need to unpivot your table to the following format in power query, click Roster and As of column, then selet unpivot other columns.
it will be the follwing format.
2.Then in power bi desktop , create a calcularted column.
Column = [As of]&"-"&[Attribute]3.in visual store, select the simple waterfall.
4.Then put the following field to the visual.
5.Then in Define Pillars, select the end cfte of each year.
6.Then select sort by column and descending.
Output
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi CJS1199
You can refer to the following solution.
1.You need to unpivot your table to the following format in power query, click Roster and As of column, then selet unpivot other columns.
it will be the follwing format.
2.Then in power bi desktop , create a calcularted column.
Column = [As of]&"-"&[Attribute]
3.in visual store, select the simple waterfall.
4.Then put the following field to the visual.
5.Then in Define Pillars, select the end cfte of each year.
6.Then select sort by column and descending.
Output
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much, I think this should work perfectly! I am going to give this a go today and I'll report back with any issues. I like how this visual from the store lets you define the pillars you want as a 'total' like you can do in the Excel version.