Single-Value Slicer

Hi Anonymous,

Step 1: Create a Measure for the Minimum Value

Min_Value = 
VAR SelectedMetric = SELECTEDVALUE('Metrics'[Metric])
RETURN
CALCULATE(MIN('YourTable'[SelectedMetric]), ALL('YourTable'))

Step 2: Create a Parameter Table for User Input

Power BI slicers do not support direct value input, so you'll need a What-If Parameter to allow users to enter a minimum value.

1. Go to: Modeling → New Parameter → Numeric Range.
2. Set up the parameter:
   • Name: MinThreshold
   • Data Type: Whole Number (or Decimal based on your data)
   • Minimum: Use a small reasonable value (e.g., 0)
   • Maximum: Use a large reasonable value (e.g., MAX(YourMetricColumn))
   • Increment: 1 (or any appropriate step size)
   • Default Value: You can set it later using the measure you created earlier.

This creates a table (MinThreshold) with a column [MinThreshold].

Step 3: Create a Measure for Filtering Data

Filter_Measure = 
VAR MinInput = SELECTEDVALUE(MinThreshold[MinThreshold])
RETURN
IF( MAX('YourTable'[SelectedMetric]) >= MinInput, 1, 0)

Step 4: Apply the Filter to Your Visuals

1. Add the MinThreshold slicer to your report.
2. Add the Filter_Measure as a visual-level filter for your table or chart.
3. Set it to show only values where Filter_Measure = 1.

Now, when the user selects a value from the slicer, it will filter the data to show only records where the metric is greater than or equal to the selected minimum value.

Step 5: Set Default Slicer Value to the Minimum

Since Power BI slicers do not dynamically adjust to show the minimum value by default, you can pre-select a value close to your actual minimum when setting up the slicer.

To make it more dynamic, consider using a Card Visual to display the actual minimum value (Min_Value measure) and guide users to adjust the slicer accordingly.

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Hi Anonymous 

 

You can create a numeric range parameter which automatically creates a single value numeric slicer

Modify the parameter value measure it creates by adding the alternative value (minimum) if no value is inputted.

Parameter Value = SELECTEDVALUE('Parameter'[Parameter], [Min Qty])

 

Create a measure that returns only the rows that are >= the slicer value.

Filtered Qty =
IF ( SUM ( 'Table'[Quantity] ) >= [Parameter Value], SUM ( 'Table'[Quantity] ) )

Please see the attached sample pbix.

 

If this isn't what you're looking for, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. Please also read this post: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523