Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |