What if parameter to display min and max

[Anonymous]

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.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

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

[v-frfei-msft]

Hi @Anonymous,

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

Regards,
Frank

[Anonymous]

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

Hi @Anonymous

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