Sorting by value a field parameter in a Matrix table

[ClaraBcn]

Dear network,

I have an issue with Field Parameters as I can't sort the values by my main field parameter which is A24. Values get sorted by alphabetical order. I found a workaround for column chart visuals but no solution yet for the matrix. Does anyone has a solution for that?

Thank you!

[ClaraBcn]

No, my field parameters are these ones (Main scenario, Comp scenario (1) and Comp Scenario (2):

Actually I want that my matrix table gets sorted out by the dynamic chose of the measure that is selected from Main scenario (it can be A24, A23, A20, B24.., etc). The sorting needs to be related to the sales amount of that particular measure as I'm showing top 10 products.

[audreygerred]

Are A22, A23, and A24 the field parameter values? If they are, you can click on the field parameter table so that you can see the DAX and then you can change A24 to be 0, A23 to be 1, and A22 to be 3. The numbers listed in the DAX are the order the field parameters show up in. Here is how you can edit it after it is created: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters#edit-a-field-par...

When you create the field parameter in the first place, you can drag and drop to get them in the order you want, but once it is made you need to adjust the DAX numbering for the order.