Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Multiple Numeric Range with Slicer

Hi,   I want to add a numeric slicer to help user select the range for that numeric field. That works. But now I want to provide multiple range selection on the same numeric field to the user. I h...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Anonymous 

    You can use Numeric range parameter to achieve your need.

     


    hide the slider

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Anonymous 

Thanks for Vidushi_Mangal reply. You can try grouping your data to achieve your need. 

Choice = 
SWITCH(
    TRUE(),
    'Table'[Value]<=20,"1-20",
    'Table'[Value]<=40,"20-40",
    'Table'[Value]<=60,"40-60",
    'Table'[Value]<=80,"60-80",
    'Table'[Value]<=100,"80-100"
)

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Yang,

 

Thanks for your reply. The user does not want to select from a range from a predefined groups by grouping the data , but wants free text field/s to enter range like this for e.g. 
12345666- 12557000. And they want to enter multiple ranges as well at a time seperated by  like 12345666- 12557000, 12345777- 12558000. Now the data has to be filtered based on what they enter in free text field/s. I have not figured out how to take inputs from the user in PBI in free text field/s and use it for filter.

Thanks