Order of elements in a filter

[SRK_23]

Hi,

How can I choose the order elements are listed in a filter ? In the example bellow, I would like to have:

0-100K

100K-1M

> 1M

Thanks

[v-jiascu-msft]

Hi @SRK_23,

Could you please mark the proper answers as solutions?

Best Regards,
Dale

[SRK_23]

yes, thanks !! 🙂

[AUYS93]

Hi @SRK_23,

Just a heads up if it still does not work, because mine did not work despite using index to sort. I did a dirty trick by adding space in front of the text, and it does not show on the filter. 

Tedious, yes, but hey it works 🙂

Regards,

AYS

[v-jiascu-msft]

Hi @SRK_23,

You can add an index column either in the data source or in the Query Editor. Then follow the guide in the snapshot.

Best Regards,

Dale

[SRK_23]

Hi @v-jiascu-msft, thanks for the answer, not sure to understand how to do it because it is not a 3 lanes colomun, see below:

[v-jiascu-msft · Accepted solution]

Hi @SRK_23,

Seems you don't have an independent table. I would suggest you add a conditional column in the Query Editor. Please refer to the snapshot below. Then apply "Sort by Column". NOTE, all values should have an index. 

Best Regards,

Dale