Forum Discussion

kmilarov's avatar
kmilarov
Helper II
3 years ago
Solved

Input/Add two parameters via slider Between

Guys, I have a slider with single input that add one parameter / variable). But want to have slider BETWEEN that enters/inputs two parameters - lower and upper  (between). values for example, to add input number via slider between 4 and 8, and to  have two var parameters values one for 4 and the other for 8?

  • Hey kmilarov ,

     

    assuming you have a table containing a column with all the possible numeric values, then you can use a single slicer and the slider "between" option to visualize the values. In my example the table and column have the same name: 1 to 100.

    Using two measures like below:

    minValue 1 to 100 = CALCULATE( MIN('1 to 100'[1 to 100] ) )

    and

    maxalue 1 to 100 = CALCULATE( MAX('1 to 100'[1 to 100] ) )

    Allows something like this:

    Of course, you can use both measures inside a third measure to add the min and max value.

     

    Hopefully, this will help you find what you are looking for.

     

    Regards,

    Tom

2 Replies

  • Hey kmilarov ,

     

    assuming you have a table containing a column with all the possible numeric values, then you can use a single slicer and the slider "between" option to visualize the values. In my example the table and column have the same name: 1 to 100.

    Using two measures like below:

    minValue 1 to 100 = CALCULATE( MIN('1 to 100'[1 to 100] ) )

    and

    maxalue 1 to 100 = CALCULATE( MAX('1 to 100'[1 to 100] ) )

    Allows something like this:

    Of course, you can use both measures inside a third measure to add the min and max value.

     

    Hopefully, this will help you find what you are looking for.

     

    Regards,

    Tom