cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GrahamR99 Regular Visitor
Regular Visitor

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 Established Member
Established Member

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 Established Member
Established Member

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 Regular Visitor
Regular Visitor

Re: A list of top 10 sold products

Hello

Can you provide the DAX I need please?

 

Regards

 

GrahamR99

jcarville Established Member
Established Member

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 Regular Visitor
Regular Visitor

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 Established Member
Established Member

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 Regular Visitor
Regular Visitor

Re: A list of top 10 sold products

Thank you for your help.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 86 members 1,352 guests
Please welcome our newest community members: