Custom filter order without referential column/table

[tslowik131]

Hi,

I want to have a specific order in a filter without creating some custom columns/referential tables. I'm connected to the dataset, hence I can't create such columns, otherwise I'd do so.

Is there a way to do it? I tried experimenting with virtual tables and switch, but it didn't work in a filter context, only for normal tables.

Thanks a lot!

[amitchandak · Accepted solution]

@tslowik131 , No as of now you need to have a sort column to change the other other than asc or desc.

If you are not in direct query to live you should be able to create a sort column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[tslowik131]

Thanks a lot for the confirmation.

I'm connected live to the dataset and all the options for creation of columns are diasabled, so unfortunetly it doesn't work.