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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Creating a bucket for the catagorys with the smallest values

Hi all, I've not been able to find the answer to this one...  Although I feel it should be simple.

 

I've created a chart with a count of people on a certain pathway.  There are 22 pathways in total, but I'm sure everyone will agree, 22 bars on a chart just looks horrible.

 

So I want to just show the top 5, and then have a 6th bar for "other".

However the data is live, so I can't group by name of pathway, it needs to be linked to the value.

 

I've tried grouping the data, but this seemed really messy and i couldn't relate it to the value of the data either.  Is there a better way of doing it?

 
5 REPLIES 5
Anonymous
Not applicable

Right so almost there.  I've got 2 charts using the same data at the moment.  The top bar chart shows the top 5 categorys by volume, which is great.  I then want to show the same set of categorys within the bigger picture of all categorys but because there are so many categorys my pie chart is a mess:

davehsongwriter_0-1649926633406.png

I want to be able to group categorys 6+ together into an "other" category.

 

This page appear to go through what I need but its confusing the heck outta me: Showing the top 5 products and Other row - SQLBI

 

Can anyone explain in basic language what I need to do?

 

 

To be able to display "Others" you need to create a new table, which I think you cannot do if the connection  is live. Or can you?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

So the "TopN" works and can give me the top5, but I want a 6th bar for "other" as well, which has all other catagories grouped together.  

Is there a way of grouping any catagory that isn't in the top 5?

Anonymous
Not applicable

Ah got it, I had to put the measure into the value box, rather than the field category.  that seems to have sorted it.

Anonymous
Not applicable

Ah ha. I've just found the "TopN" filter type... trying that now...

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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