Create Waterfall Chart

[Siddharth_2987]

I have a table with Region and Population as attribute. Where the population of India (Country) is bifurcated into tagged region named as East, West, North and South, and untagged region is named as Other. Other = India - sum(East,West,North,South); so as per the value Other = 2500.

I need to create the model in PowerBI. I tried using the Query Editor but struggle to obtain the result as mention below in Waterfall chart. Help will be appreciated.

[Anonymous]

Hi @Siddharth_2987 ,

You [India] column is the total below. You should 

Then you have to create an index column and have the region column sort by the index column. In my case, Column1 is the index column.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Siddharth_2987]

Thankyou for taking interest in addressing my concern.

Solution provided by is very generic. I have data counts for 10000 rows and was tagged for East, West, North and South. I have to create the custom calculation to get the data for Others ( Total -Sum(East,West,North,South).