Multiple Numeric Range with Slicer

[ruchikhanuja]

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 have tried couple of option but in vain.

Any pointers would be helpful.

Thanks!

[v-yaningy-msft]

Hi, @ruchikhanuja 

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

[ruchikhanuja]

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

[Vidushi_Mangal]

you can Create calculated fields that represent different ranges based on user input and you can use parameters to let users specify the range boundaries.

Key points for this approach is that : This approach is relatively flexible and doesn't require custom development but It might involve more complex interactions for the end-user compared to dedicated slicers.

Give thumps up if it works

[v-yaningy-msft · Accepted solution]

Hi, @ruchikhanuja 

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

[ruchikhanuja]

Thanks Vidushi for your reply. The user 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 free text field/s and use it for filter.

Thanks