Forum Discussion
Advocate IIError with Other category in Waterfall chart
Hey
I cannot understand why instead of one city it show *Other* then there is city selected as Breakdown.
Here is the workbook on Onedrive: https://1drv.ms/u/s!ApPjjxMw3nlvwyOAk_Lv69Mh3P0k
Ignas
I have found the problem. We need to change the MAX breakdown:
5 Replies
- ignas
I have found the problem. We need to change the MAX breakdown:
Thank you!
HI ignas,
I can't reproduce your issue with other data, I also not sure why it will generate 'other' category.
Maybe you can contact to power bi team with sample file to confirm if it related internal calculation of dax formula.
Regards,
Xiaoxin Sheng
- ignas
Hey Anonymous
Thanks for the try. How can I contact PBI team?
Power BI automatically detects the Top 5 biggest contributors to your increase or decrease. In your case the top 5 cities. Whereas the rest is grouped in a category called "Other". You can modify this by changing the maximum breakdown number.
Check this video for more detail: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-waterfall-charts
