Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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
Solved! Go to Solution.
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
Can you provide the DAX I need please?
No DAX is needed, use my post above along with the screenshot below for your solution.
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?
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.
Thank you for your help.
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
