Forum Discussion

pab11's avatar
pab11
Icon for Helper I rankHelper I
5 years ago
Solved

Numeric range slicer not available

Hello Everyone,   I'am trying to create a slicer in which i can select a certain range of numbers, like this:   But I don't get listed the options to alter the slicer. I only can select "Li...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ok, it's a numeric field.

    I trust you exported or did something to look for all the nulls.

    Look under File/Options&Settings/Options and in the list select preview features. 

    Make sure Numeric Range Slicer is checked.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It is due to the Nulls (sorry, too busy to make a test for you). There also may be text in there and that definately would stop that slicer. 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

I have a column INDEX, which has a datatype as WHOLE NUMBER. I can see an option for it to create a range in slicer. See below:

 

 

 

The only thing is this column hasn't got any null values or blank values in it.

 

Ideally, in your case if a numeric column has got NULLS or SPACES, then logically it is wrong from data point of view. You will need to clean your data and replace these NULLS and SPACES with a random value, could be ZERO if works in your scenario.

 

Thanks,

Pragati