Top N & Other Issue

[Anonymous]

Hi there,

I created a calculated table with top items and "other" because I wanted to show "Other" in my pie charts. When I click on the "Other" category it does not show the other values and location descriptions on the dashboard. Is this possible?

I created the Top & Others using these instructions:

https://www.proserveit.com/blog/ms-power-bi-topn-and-other

[v-juanli-msft]

Hi @Anonymous 

As tested with the link, it would finally show "other" with its total value.

As there are many items in "other" category, it doesn't seem good to show all other details.

If you really need, please let me know and show your expected result as an example.

Best Regards

Maggie

[harshnathani]

Hi @Anonymous ,

Based on the blog.

You would have create a measure

Top Trading Partner and Other .

Instead of pulling Sales. Pull this measure in the visual. This will show you the Top 10 and other Total.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[amitchandak]

@Anonymous , how you created Top 5 + Others?

[Anonymous]

Hello,

I created using these instructions:

https://www.proserveit.com/blog/ms-power-bi-topn-and-other