Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
cristio
Helper I
Helper I

Hello I need help fast with Power bi. How can I sort for top 10 most profitable products?

Hello,

 

I have a table inserted in my dashboard.  The problem is that in the filters pane, I can`t sort it by the top 10 most profitable products by product name. I want the table to show the product name and the first up to 10 positions how much profit each product has made in the grand total. But the filters pane won`t allow me to sort the top N product name by the Total Profit measure.

Can someone please help me? I`ll attach the PBIX.

Also, as you can see, there is up there a slicer with the months, the months are not ordered correctly, starting with January and ending to December, they are sorted alphabetically I know I have to do something with sort by column but I don`t know the whole process I don`t know I guess I forgot it.

 

https://drive.google.com/file/d/18eF_-VyfyQc5tONk3hRTZyyW7NAfjASp/view?usp=sharing

 

Please take a look at the PBIX

Thank you

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @cristio ,

 

Please refer to this article that would walk you through the process of acheiving what you're asking for.

https://radacad.com/top-n-filter-in-power-bi-with-zero-dax-code-visual-level-filter

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Hello, I`ve already tried that it`s not what I`m asking . Please download the PBIX. And look why I cant filter by top N via the Total profit measure

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.