How to sort in a Slice

[Dave_Willett]

I have the following expression:

isnotblank([Replacement_VehicleReg])

Which needs to be sorted by date order asc [WEC]

There are plenty of examples in the community, I just can’t find one which suits my purpose.

Is it possible for a solution?

Kind Regards

[Aleksi]

Don’t know exactly where are you trying to sort it but I’m assuming you are trying to do that with a dropdown. If you are trying to read values with a normal column, you can sort the order just with the SORT() expression but that doesn’t give you the option to sort with another column. The only way you can sort the order is the ORDERBY() but that works only with the Key column.

[Dave_Willett]

Ok Steve, its just that when the Report is run:

I would be ideal to ASC on the WEC date, but I’m uncertain how to acheive that.

[Aleksi]

Then you can use the ORDERBY() like <<Start: ORDERBY(TableName[KeyColumn],[WEC],FALSE)>>

[Dave_Willett · Accepted solution]

Aleksi:

<<Start: ORDERBY(TableName[KeyColumn],[WEC],FALSE)>>

Perfect Aleksi, something else I have learned today.

Cheers Guys

[Aleksi]

You’re welcome