Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Waterfall Chart

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