cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AndyB
Frequent Visitor

Table Top N Display (Duplicates)

Hi All

 

Got a couple of questions for something I'm trying to set up - but unfortunately hitting a bit of a wall as to whether it's possible.

 

Sample: 

Table is of Category, Subcategory, Item, Ticket Count

Top N Filter Applied to Item (based on Ticket Count Value)

 

Table Sample.png

Filter.png

Desired Result: 

Table is sorted by Top 10 Items, no other rows past the top 10 items should display. 

 

Problem: 

As shown in the image above; there are more than 10 rows. I suspect that these are as a result of the same item being present with a different Category or Subcategory; however I need to have all 3 listed in the table for the purposes of the report I'm making.

 

Is there some kind of measure that I can set up to rank these (which will update on the weekly basis that this report is required for) to filter out any additional rows past the top 10?

 

Thanks in advance!

Andy

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Table Top N Display (Duplicates)

Hi @AndyB 

Please refer to the following:

How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter)

Dynamic Top N with what-if parameter

 

Feel free to ask me for any question.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
jbarnes Resolver II
Resolver II

Re: Table Top N Display (Duplicates)

I would just apply the Top 10 N to a different field?

 

use Top 10 Ticket ID under Category rather than filter?

I hope this hels.

Community Support
Community Support

Re: Table Top N Display (Duplicates)

Hi @AndyB 

Please refer to the following:

How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter)

Dynamic Top N with what-if parameter

 

Feel free to ask me for any question.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors