Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
Solved! Go to Solution.
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.
Regards,
Frank
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.
Regards,
Frank
Hi @schwinnen,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
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.
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.
Is it what you need ?
Regards,
CR
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |