Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
schwinnen
Helper V
Helper V

What if parameter to display min and max

Is there a way to get a parameter control to show the minimum value and the maximum value?  For example, if I have a slicer that shows values from 0-100, I would be able to slide the slicer both ways to show values between 50-60.

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @schwinnen,

 

To change the slicer like this. If that doesn't meet your requirement, kindly share your sample data and excepted result to me.

 

2.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

4 REPLIES 4
v-frfei-msft
Community Support
Community Support

Hi @schwinnen,

 

To change the slicer like this. If that doesn't meet your requirement, kindly share your sample data and excepted result to me.

 

2.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @schwinnen,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

@v-frfei-msft

It is not really a solution to my problem, but I marked it correct as it may help someone with a similar problem.  I realized after the fact that I don' t think this will work for what I am trying to do.  In order to create a parameter for an aggregated value, someone else taught me this formula:

 

# LOADS for DESTINATIONS Above Selected LOADS Parameter = 
VAR LOADParam = [MIN LOAD VALUE]
RETURN
CALCULATE(
    [# LOADS],
    FILTER(
        VALUES(QA[DESTINATION]),
        [# LOADS] >= LOADParam
    )
)

Since this formula is specifically calculating MIN LOAD VALUE, I don't think I can have a max value on my parameter.  I think I would have to create a separate formula for MAX LOAD VALUE and then a separate parameter.  

 
CR
Resolver II
Resolver II

Hi @schwinnen

 

I propose you to add a slicer with the column containing the values 0 to 100 (0to 30 in my sample). Then you will be able to play with the slider to display50-60, etc.

 

1.png

Is it what you need ?

 

Regards,

CR

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.