Waterfall chart

[lucadiielsi]

Hi everybody,

I need to replicate a waterfall chart made in Excel, with the dataset I attach below. The Excel file has 3 sheets:

1. Test: the data in their original format (starting point)

2. Resume: a middle step in order to obtain the desiderd result

3. Mockup: the waterfall chart the way I would like to be

With the PBI waterfall visual I'm not able to get the same result you can see in the Excel. Could someone help me? 

Thank you very much,

Luca

https://www.dropbox.com/s/dh5w2sfu7axq1j5/Test%20waterfall.xlsx?dl=0

[v-chuncz-msft · Accepted solution]

@lucadiielsi 

You may try Unpivot Columns, Group By and Append Queries in Query Editor.