How to sort columns in a matrix by measure value?

Hi Robert14358 

If the sorting must be dynamic I am afraid that we don't have this functionality with the core matrix visual.
There is an idea about the issue you can vote for it here :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=905c11cc-3315-ec11-b76a-281878bd1a87

There is a free matrix from the marketplace that can sort the columns too :

I attached the pbix for my response to follow

+ inforiver visuals have this functionality too , but for pay 

P.S

If for a moment we disconnect from the technical aspect, it’s also important to note that ranking from large to small shouldn’t be horizontal, but vertical. In other words, the metrics should be in 'rows.'

The horizontal axis is a logical axis (like in distribution graphs), and its logic is consistent — a timeline moves from old to new, a range axis moves from small to large.

When we change these concepts, we make it harder to read the visualization. Therefore, regardless of the tool's technical limitations, I strongly recommend that the 17 categories you're comparing be arranged vertically, and whatever you are comparing them against (if it's some logical axis) should be arranged horizontally.

And if it's just hierarchical groups (lists within lists), it’s better to create a hierarchical matrix without column divisions:

there is currently a suggested idea that is open for this for over 4 years, can all of you who saw this request please go and vote for it?

Microsoft Idea

this is a basic excel function and needs to be in power bi.

Is it a single row?  how should it be sorted if you have multiple rows?

no i need this in a maxtrix, pretend its a sum of sales where the row is product and the column is country, i need to sort the columns based on sales by country