Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Slicer with range values for Text

Hi

I have an customernum with alphanumeric values with text data type but will be in sequence order

1000
1001
....
....
....
A1000
A1001
........
........


Now I want to use this value in slicer with between operation

How to do this ?

 

thanks

Need Help
Show and Tell

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Instead of a slicer use the filter pane. It gives you the flexibility to indicate ranges etc.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      lbendlin 

       

      Thanks for the update, but i'm not able to see the ranges in the filter pane.

      How can i get the ranges for "Text" data type.

       



      please find the below screensot for reference, what i'm looking for.

       

      The bleow case which i have done is i have created a sort number for CustomerNum and added it,

      then i'm using that sequence number for slicer. as below

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Interesting - the advanced text filters do not allow for "greater than"  etc options

         

        Never mind then.