How to change a Sort By Column in a Table based on selected value

[nb2310]

I have a Table which shows the Top 5 Countries based on various values like Net Sales, Gross Margin, Net Profit, etc using Top N filter.

Currently it is sorted by Markets name and I can change the sorted column des or asc when I select the column. But this method is static.

Is there a way to change the sorted Column based on the selected value? For ex. if I select NP $, can the table automatically sort by NP $ column descending? and then if I change selection to GM $, can the GM $ column in table be sorted descending?

I'm new to Power BI so any answer will be helpful! Thanks!

[nb2310]

Thank You!

[POSPOS · Accepted solution]

@nb2310  - Have you used buttons for the Top 5 Markets by: ?  If yes, you can create 5 different tables then use bookmarks for each of the buttons. Each table will be sorted by default on the respective measures.
Eg : Table 1 will be sorted by NS $, Table 2 will be sorted by GM $ etc.... This way, when you select on any button, they will be sorted accordingly