Forum Discussion

Nata800's avatar
Nata800
Regular Visitor
3 years ago

Convert table structure for waterfall chart

Dear all,   I have following table structure with revenues for 2022 and 2023 as well as delta revenues 2023 vs. 2022 per Country. Category Breakdown Revenue 2022 2022 100 Delta Count...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Nata800 ,

Remove the bottom row in Power Query and add [Index] column to help sort.

 

The only difference with the image you gave is that 'total' is used here instead of '2023'.

 

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 in the Power BI Forum

Nata800's avatar
Nata800
Regular Visitor
3 years ago

Thanks Gao for your solution and sorry for the delay (was on vacation).

I think your solution will work, but I would need to enrich the table slightly. In my example table above the country variances are completely summing up to the delta of 2023 vs. 2022. However in reality my table does not, which means there is always a difference

 

 

So before I can use your Total column (to reflect the value of 2023) I would need to add rows with "Country Others" for the deltas within a Region (A-D). With what formula could this be achievable in Power Query?

Thanks a lot!

 

Regards
Nata