Top 15 in a report

[joschultz]

What is the easiest way to show just the top 15 items in a report?  Example is I want to show the top 15 products in sales for the day.  I will have hundreds of products in the data but only want the top 15.

Thank you,

Joseph

[Sean]

What table is the Case Description field in? And how are the tables related?

[sallen]

It's all just in the same table. For some background, I have been using Excel to do reporting for years, and I'm now starting to look into putting everything into Power BI. So I'm very new to tables and things like that. I'm actually wondering if there's some basic online training I could do to help with my understanding.

[Sean]

If its all in the same table that should definitely not happen???

[sallen]

Weird. So this is my table without the case description (everything working fine):

Without case description

And here it with the case description. All I've done to add this to the table is to drag it from the field list into the 'Values' section of the visualisation:

With case description

Thanks so much again for your help, this is really helping me understand how it all works. I think once I can work through a couple of examples I'll be able to teach myself a lot more effectively.

Stuart

[spiderrob]

Use RANKX in a measure to get rankings numbers for the particular value and then drop the measure in one of the filter areas and apply less than or equal to 15 or whatever top x you are after.