Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |