Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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

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

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.

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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