Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Indirect slicer

Hello

 

Is it possible to use a slicer with specific value/range options to filter a field in another table via a function?

 

E.g. a slicer has two options: 0 and 1.

If 0 is selected then e.g. Col1 of a table is filtered by >4.

If 1 is selected then Col1 of a table is filtered by <4. 

 

Thanks!

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    You may use SELECTEDVALUE('Table'[Column]) to get the value of the selection in slicer and store it as a Variable. 

    Now you can use this variable for calculation logic derivation.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

    You may use SELECTEDVALUE('Table'[Column]) to get the value of the selection in slicer and store it as a Variable. 

    Now you can use this variable for calculation logic derivation.