cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Prasad_Patil
Helper I
Helper I

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 @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
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors