Sort by one column in measure with switch statement

[MichielvDuppen]

I created a switch measure to dynamically show the last 12 months including YTD and YTD LY comparisons into one table. 

I visualized this measure in a pivot table where I would like to sort by one column in the switch statement (Sales YTD)

How can I do this?

[v-rzhou-msft · Accepted solution]

Hi @MichielvDuppen ,

You build a measure to show different measures in one by switch function. We couldn't sort this measure by one part measure in it.

I suggest you to add YTD measure into matrix value. Then sort by YTD measure.

Turn off word wrap function in visual format and reduce the width of columns to 0 which you don't want to see in matrix.

Result is as below.

You see my matrix is sort as descending by YTD measure.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

HI @MichielvDuppen ,

On your table visual, if you click on 3 dots on the top-right, it gives you option to sort by whichever column you want. Something like below:

Thanks,

Pragati

[MichielvDuppen]

It does not, since I only have the measure with the switch expression in my pivot table.

[Pragati11]

Hi @MichielvDuppen ,

I don't think you can sort this with the measure on the table.

Let me think if there is any other way to do this.

Thanks,

Pragati