Display TOP 10 values in Waterfall chart

[Prasad_Patil]

Hi Community..!!

Please refer below image.

This is waterfall chart. Except PY (left) and CY(right) bar, remaining in between Bars should display Top 10 bars(positive values green in color and negative values red in color), 10+ bars should comes in new bar called as Others.

Could u please help me to get the above solution.

Please let me know for any clarification.

Thanks in advance..!!

[v-jingzhang]

Hi @Prasad_Patil 

If you want to show 10+ bars in a new bar called as Others, you may need to group the categories according to values in advance and group those 10+ categories into an "Others" group. Then "Others" would be possible to appear on the x-axis. 

Can you please provide some dummy data to show the table you have, then we can think further if it's possible to accomplish the expected result based on it? 

Best Regards,
Community Support Team _ Jing

[grantsamborn · Accepted solution]

I'm not sure I understand. 

Are you trying to adjust the number of bars in between?  If so, go to the Format Visual pane and open Breakdown.  There you can control the number of breakdowns.

If not, can you please provide more detaills.