Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Slicer

Hi, is there a way to create a dynamic slicer?   Basically I have a data table that has Manager in it as one of the columns. I have a 'table' that I have created that shows the results filtered on ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

Why not directly drag Manager column from the generated 'table' into slicer?

 

For more advice, please post sample data and your expected output.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-yulgu-msft , not sure I'm getting it.

     

    I have a table based on certain criteria:

     

     

    with data in it and an empty slicer visual:

     

     

    If I pull in Case Manager from the original raw data into the slicer then I get all Case Managers, but I just want the Case Managers that are in the above table, which will be a subset of all the Case Managers. This subset will change, so I can't just select the ones it is now, might be completely different this time next month. Basically I just need to filter on Case Manager.

     

    I can't drag anything from that above table to the slicer? What am I doing wrong? Sorry fairly new to Power BI.

     

    Thanks, Andy