Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago
Solved

sort by custom Index order

Still looking for assistance in establising a correct sort order for Slicer:   I create a custom column to set the new Index order, however, when I try to implement it as a slicer it reverts back t...
  • Sean's avatar
    Sean
    10 years ago

    kfschaefer I can see the SortID was created in the Query Editor - that will not affect this!

     

    What I suggested is to concatenate the 2 Columns in the Data View and then use that new concatenated column for your slicer

     

    the concatenated column is a new column with a new name - thats why it has ! at the end

    in the Data View => Modeling Tab => click New Column => type Live Range! = .....

     

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

kfschaefer I can see the SortID was created in the Query Editor - that will not affect this!

 

What I suggested is to concatenate the 2 Columns in the Data View and then use that new concatenated column for your slicer

 

the concatenated column is a new column with a new name - thats why it has ! at the end

in the Data View => Modeling Tab => click New Column => type Live Range! = .....

 

 

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago

thanks I tried it again and this time it worked.

 

Thanks for your input.

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    You can do the same for your Month Slicer.

     

    If your Calendar Table has Month Number and Month Name Columns

     

    Create a new Column by Concatenating the 2 in the Data View

     

    So you'll get => 01 - January ..... 12 - December which you can then use as your sorted slicer