Forum Discussion
ignas
Advocate II
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_Lv69Mh3...
I have found the problem. We need to change the MAX breakdown:
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