Forum Discussion

SRK_23's avatar
SRK_23
Icon for Helper I rankHelper I
8 years ago
Solved

Order of elements in a filter

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
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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. 

    Order_of_elements_in_a_filter2

     

    Best Regards,

    Dale

AUYS93's avatar
AUYS93
Icon for Advocate I rankAdvocate I
8 years ago

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