how to display customized breakdown in waterfall chart

[Anonymous]

Hi, 

I have a waterfall chart to display the bridge of change from Jan to Aug. 

But seems by defaultly , it will not display the top 5 value . in the first chart, it shows Rouge Dior Others and Rouge Dior lip color have the most amount. But in the waterfall chart, they are all defaultly included in Others. -- because we have about 50 breakdowns. 

How can I adjust the breakdown to show the top 5 or just show as what I want?  

Thanks!

[vanessafvg]

Hi are you able to share your pbix?

[Anonymous]

Hi @vanessafvg , 

How can I share with you the pbix file?

Thanks!

[vanessafvg]

do you have a dropbox or similar?

[Anonymous]

@vanessafvg , 

No actually, dropbox is blocked here. I'm not sure if onedrive is workable? 

Thanks!

[vanessafvg]

one drive will work