cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GrahamR99 Helper II
Helper II

A list of top 10 sold products

Hello

I have a Query which is call Sales_Data, it has two columns Product_Name and Sales_QTY.

 

I want a list of the top 10 sold products, what are the steps I need to do to do this?

 

Regards

 

GrahamR99

1 ACCEPTED SOLUTION

Accepted Solutions
jcarville Skilled Sharer
Skilled Sharer

Re: A list of top 10 sold products

Bring the 2 columns into a table.

Under Filters, click on Product_Name and then change the filter type to TopN.

Enter 10, and then drag Sales_Data into the data field.

View solution in original post

6 REPLIES 6
jcarville Skilled Sharer
Skilled Sharer

Re: A list of top 10 sold products

Bring the 2 columns into a table.

Under Filters, click on Product_Name and then change the filter type to TopN.

Enter 10, and then drag Sales_Data into the data field.

View solution in original post

GrahamR99 Helper II
Helper II

Re: A list of top 10 sold products

Hello

Can you provide the DAX I need please?

 

Regards

 

GrahamR99

jcarville Skilled Sharer
Skilled Sharer

Re: A list of top 10 sold products

No DAX is needed, use my post above along with the screenshot below for your solution.

 

Capture.PNG

GrahamR99 Helper II
Helper II

Re: A list of top 10 sold products

Hello

Sorry you have given me what I asked for, but my hope was I could get it in a slicer so I can select the one of the top 10 to affect my data.

 

What do I need to do to get a slicer with the top 10 products?

 

Regards

 

GrahamR99

jcarville Skilled Sharer
Skilled Sharer

Re: A list of top 10 sold products

If you had the table like mentioned, you could still select a product and it would filter your report.

Granted it doesn't look the same as a slicer but it still offers most of the functionality.

 

Maybe someone else has a different solution.

GrahamR99 Helper II
Helper II

Re: A list of top 10 sold products

Thank you for your help.

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