Create Single Value Slicer

Hello, hope someone can help me on this report. exhausted all possible scenarios but unable to find one.

I want to create a single filter or slicer for the minimum and maximum value (for the users to have the ability to put a SINGLE value only).

for example, I have a filter selected (prob1). as per the selected filter, it should get both the minimum and maximum value that can be seen on the "probability_val" column, so the single value slicer should fall ino these values only (e.g minimum value is -4 while maximum is 349,900) so it is imperative that in the single value slicer, users can only put within this range. so both the minimum and maximum value is dynamic depending on the filter selected (probability column).

The reason behind this are as follows:
       1. Dynamic Filtering Based on User Input

• Users can set a custom range by defining a Minimum and Maximum value for the selected metric (prob1, prob2, etc.).
• This allows them to focus on applications that fall within a specific threshold.

   

  2. Default Values Based on Actual Data

  • The slicers should default to the actual minimum and maximum values of the selected metric (prob1, prob2, prob3 or prob4)
  • This ensures that when a user first interacts with the report, they see the full range of data.

    3. Interactive Data Exploration

    • Users can adjust the range dynamically, filtering out values that are too high or too low for their analysis.
    • For example, if a user sets:
      • Min Value = 10
      • Max Value = 50
      • The dataset will only show records where the metric (probability_val) falls within 10 to 50.

this is the sample data