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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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