Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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"
)
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"
)
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.
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)
Thank you, it works now.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |