waterfall

[papuzu]

Hello everyone

I’m trying to create a waterfall analysis. I have done a test with spare numbers with several products referring to 3 macro Line of business. In the future there can be also more aggregate layer of Line of business and I would like to create a dynamic calculation of the categories of the waterfall but this is a further steps

Basically I’ve found an example as per attachement but I’m already stucked with excel upload because it gives errors on most of the tables in particular the Breakdown and Category table I’ve created which I understand they are required to proceed in the walkanalysis process

Do you know what it is wrong about these the tables I’ve created that I cannot neither upload ?

Excel with data example to be uploaded

https://docs.google.com/spreadsheets/d/1am5P38I8EitJH4nME3Ek4HlkatT-46kS/edit?usp=sharing&ouid=11176...

Power BI Template which I would like to copy

https://drive.google.com/file/d/1S9Q3z0M5kocQDphw5MmNe7AAU6BhP4S2/view?usp=sharing

thanks for help in advance

[papuzu]

hello everyone, do you think is too much articulated my query ? thanks for what it might be needed to be adjusted for a faster reply, 

best 

P

[v-cgao-msft]

Hi @papuzu ,

The first link returns an error, and the second requires permission. Could you please share it again? Thank you!

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[papuzu]

thanks, now it should work 

by the way I did not find any help on link provided for what it regards data upload strictly to file. It was definying how to upload data table If I'm right 

Best Regards

A

[papuzu]

Hello everyone , has anyone succeeded to open link ? 

Do you think is to complex the question put on this way all together ? 

Thank you for your advice