cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V

## 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
Community Support

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
4 REPLIES 4
Community Support

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support

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 others find it more quickly.
Helper V

@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 =
RETURN
CALCULATE(
FILTER(
VALUES(QA[DESTINATION]),
)
)```

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.

Resolver II

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.