March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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?
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:
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?
Proud to be a Super User!
Paul on Linkedin.
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?
Ah got it, I had to put the measure into the value box, rather than the field category. that seems to have sorted it.
Ah ha. I've just found the "TopN" filter type... trying that now...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
83 | |
76 | |
62 | |
58 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |