cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
schwinnen Member
Member

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

Accepted Solutions
Community Support Team
Community Support Team

Re: What if parameter to display min and max

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 other members find it more quickly.
4 REPLIES 4
CR Member
Member

Re: What if parameter to display min and max

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

 

 

Community Support Team
Community Support Team

Re: What if parameter to display min and max

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 other members find it more quickly.
Community Support Team
Community Support Team

Re: What if parameter to display min and max

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 other members find it more quickly.
Highlighted
schwinnen Member
Member

Re: What if parameter to display min and max

@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.