Error with Other category in Waterfall chart

[ignas]

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

[SamsonAnalytics]

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

[ignas · Accepted solution]

I have found the problem. We need to change the MAX breakdown:

[rickystudds]

Thank you!

[Anonymous]

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?