Sorting on Parameter fields measures

v-yadongf-msft well yeah of course I can sort it manually but the whole purpose of using Power BI is to make data handling better, easier to use and visually better than manual work 😁.

Anyway thru several online post I came up with a solution myself for this problem.

First of you need to make an extera column in the parameter field table:

It is a copy of the main column in the table but for some reason you cannot use that one.

(getting error about the composite key etc)

When you have that you kan make a variable Rank Measure like:

And when you switch to USD view:

Works like a charm! 😁

And if you don't want to show the rank measure in your visual you can turn word wrap of in column header and the values and then you can just hide the column by sliding the width all to the left making it so narrow that it will nog show anymore.

For a chart even more easy, you just put it in the tooltips and then you can still sort on it but it won't show in the graph.