Waterfall Chart

[Anonymous]

I am new to power BI and struggling to create a waterfall chart to show the changes from Forecast total to Actual total. Forecast total is the starting point and Actual total is the ending pointing with the variance explained by/attributed to the Country. I have put the Country Code field under Breakdown, Target and Actual under Category in the chart. Y-axis is the variance between Target and Actual calculated using measure. However, I failed to get the result for the waterfall chart as you can see the PBI chart in the given link below.

I can't figure out what is wrong and why there is "Other"  in my chart when my table has only 6 countries.

Any help or advice would be greatly appreciated. 

https://drive.google.com/open?id=1sZTBg_W4kgTlX7Lucu7HhYOvyRug3eu7&authuser=1&usp=drive_link 

Thanks,

Doris

[Anonymous]

Hi Ibendlin,

My apology for the late reply.

Please try again to download the pbi file from this link:

https://drive.google.com/file/d/11LC1jXPsiucNU255MVVDdgUMGofvyspn/view?usp=sharing

Thank you.

[lbendlin]

Please check the download link, access is denied.