Forum Discussion
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
2 Replies
- lbendlin
Super User
Please check the download link, access is denied.
- AnonymousNot applicable
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.