Forum Discussion
Sorting by value a field parameter in a Matrix table
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...
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-parameter
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.