Single-Value Slicer

[Anonymous]

Please help. How to achieve this? Single-Value Slicer for Minimum Value - where users can input a Minimum Value for the metric selected. This will filter the data to show only values greater than or equal to the specified minimum. The default value for this slicer will be the actual minimum value of the selected metric

Thank you.

[grazitti_sapna · Accepted solution]

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!

[Anonymous]

Hi @Anonymous ,

Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

Best Regards,
Stephen Tao

[danextian · Accepted solution]

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

[grazitti_sapna · Accepted solution]

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!