Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How can I create a dynamic filter based on a Parameter?

Hello,   I have a visual below that uses a Parameter in the Rows (BU), that is driven by the "Detail" parameter above it. User can change it to another item to change how they slice the data.  M...
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    Hi Anonymous 

    Just to confirm, you want to add a slicer that contains the values of the field selected in the "Detail" slicer?

     

    If so, make a copy of the existing Detail slicer, right-click the field in the new slicer's field well and select "Show values of the selected field". The new slicer will now contain the values of whichever field is selected on the first slicer.

    Regards

OwenAuger's avatar
OwenAuger
Super User
2 years ago

Hi Anonymous 

Just to confirm, you want to add a slicer that contains the values of the field selected in the "Detail" slicer?

 

If so, make a copy of the existing Detail slicer, right-click the field in the new slicer's field well and select "Show values of the selected field". The new slicer will now contain the values of whichever field is selected on the first slicer.

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes exactly! Thank you, I did not know this was a thing. I really appreciate your help!