Reply
Member
Posts: 79
Registered: ‎07-25-2018
Accepted Solution

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.


Accepted Solutions
Community Support Team
Posts: 2,214
Registered: ‎07-10-2018

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.

View solution in original post


All Replies
CR Member
Member
Posts: 53
Registered: ‎04-20-2017

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
Posts: 2,214
Registered: ‎07-10-2018

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
Posts: 2,214
Registered: ‎07-10-2018

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.
Member
Posts: 79
Registered: ‎07-25-2018

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.