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

[cristio]

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

[Idrissshatila]

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

[cristio]

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