Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Display TOP 10 values in Waterfall chart

Hi Community..!!

Please refer below image.

Prasad_Patil_0-1667831138336.png

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..!!

1 ACCEPTED SOLUTION
grantsamborn
Solution Sage
Solution Sage

Syndicated - Outbound

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.

 

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

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
Solution Sage
Solution Sage

Syndicated - Outbound

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.

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)