Dropdown menu for a slicer

[Anonymous]

Hello!

I'm trying to figure out how can i make a dropdown menu for my slicer that will show a range for my numbers for example 7000-8000 and after clicking it will show all of the numbers that are between that criterion.

I have numbers from 4000 to 11000

[themistoklis · Accepted solution]

Hello @Anonymous ,

Create a new calculated column (not measure) with number groups (ranges). Use the formula below. Then add it in a slicer

Group Values=
SWITCH (
    TRUE (),
    Table1[column X] >= 0
        && Table1[column X] < 7000, "0-7000",
    Table1[column X] >= 7000
        && Table1[column X] <= 8000, "7000-8000",
    "other"
)

[Anonymous]

@themistoklis

I right clicked my table and selected "New column" and used the code that you made.

I'm getting an error "Unexpected expression" in few spots in the code.

This is your codeI added a semicolon behind TRUE(); and "0-7000" and "7000-8000"; and it still complaining.

[themistoklis]

maybe it has to do with your regional settings... instead of comma (,) use semicolon (;) in the formula

on the second image you have commas in couple of places (before the number range)

[Anonymous]

Thank you, it works now.