Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |