Waterfall bridge with too many variables

[hidenseek9]

Power BI community, 

I need a help with making this waterfall chart prettier. 

Sample BI 

I have a waterfall chart comparing cost by vendors. 

However, I have 100 vendors and this bridge is too difficult to see. 

I only want to show a waterfall bridge with 10 vendors and rest as "Others". 

How can I show top 10 vendors with the biggest variance and group the rest as "Others"?

Also, I would like to create a table with a top 10 vendors by cost and how cumulative % share such as below. 

Regards,

H

[lbendlin]

Apologies I had missed that link. 

Do you want the TOP x to be flexible?

How can I show top 10 vendors with the biggest variance and group the rest as "Others"?

Please define "biggest"  - By value, by percentage?  Absolutes?

[hidenseek9]

Yes top 10 vendors need to be flexible as they change every month.

The biggest by the highest spenders by value. 

[lbendlin]

That would show only the top 10 positive values.  Not a real bridge?

[hidenseek9]

Apologies for a slight confusion.

I want 2 outcomes in this report. 

1. A bridge to simply capture top 10 vendors (in absolute value) and the rest grouped as "others"

2. A list of top 10 vendors/spenders by value

These 2 top 10 will not match since 1 is in absolute and 2 is in value.

Regards,

H

[lbendlin]

here's a first approximation, showing the top 20 contributors by absolute variance.

I am not sure this will help much though as the "Other"  chunk is much bigger.

[hidenseek9]

This is amazing Ibendlin!

This is a dummy data I created for this practice. 

In real data, what would be classified as "others" are many variances close to 0, which I want to group them together. 

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[hidenseek9]

If you were unable to access the link, please try again with below. 

Sample BI 

In the BI report, it shows the waterfall chart as shown in the screenshot as well as the full set of data. 

Regards,

H