Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer Filter

Hi,

 

I have a table like this right now:

 

Is it possible for me to create a slicer where it prompts the user's input? For example, if the user input 0.4, it will show the jobs which has a rating below 0.4

 

Thank you!

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    hi,

    Please check the below picture and the attached pbix file.

    I suggest creating a "Numeric range parameter" from Modeling tab.

     

     

     

    Rate by slicer measure: =
VAR _slicer = Slicer[Slicer Value]
RETURN
    CALCULATE ( SUM ( Data[Rate] ), FILTER ( Data, Data[Rate] <= _slicer ) )

     

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    hi,

    Please check the below picture and the attached pbix file.

    I suggest creating a "Numeric range parameter" from Modeling tab.

     

     

     

    Rate by slicer measure: =
VAR _slicer = Slicer[Slicer Value]
RETURN
    CALCULATE ( SUM ( Data[Rate] ), FILTER ( Data, Data[Rate] <= _slicer ) )