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...
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 ) )

     

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 ) )