Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Numeric slicer doesn't work in Desktop

Hi,

I have a numeric field in my slicer but it only shows the options list and drop down. I want a between-slicer. What's the trick?

Anonymous
8 years ago
I've found the trick ; http://community.powerbi.com/t5/Issues/Numeric-range-slicer-still-not-working-in-October-2017-desktop/idi-p/290953

5 Replies

Omega
Impactful Individual
8 years ago
Change the data type, in the modelling ribbon, of your column to Decimal number.
v-sihou-msft
Microsoft Employee
8 years ago
Anonymous

It shows List and Dropdown only means it's not a numeric field. Either "Whole Number" and "Decimal Number" can be applied between slicer.

Please verify the data type under Modeling.

Regards,
- Anonymous
  Not applicable
  8 years ago
  It is a whole number....?
Anonymous
Not applicable
8 years ago
Same issue here. I have a list of priorities coming from 1 to 10.
Either decimal or whole number only shows it as list or dropdown.
Anonymous
Not applicable
8 years ago
I've found the trick ; http://community.powerbi.com/t5/Issues/Numeric-range-slicer-still-not-working-in-October-2017-desktop/idi-p/290953