Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamically choose columns values based on slicer

I have a dataset below in my report.   My report is like below... I want to have a filter in slicer with the values "Include" or "Exclude" so that when we ticked the Include filter...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    I think using the bookmark feature will be better. Create report bookmarks in Power BI to share insights and build stories - Power BI

    Filter the category values on the table visual and add a bookmark. Clear the filters and add another bookmark. 

    Insert two buttons into the report, turn on their action and set their action type to bookmark. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

I think using the bookmark feature will be better. Create report bookmarks in Power BI to share insights and build stories - Power BI

Filter the category values on the table visual and add a bookmark. Clear the filters and add another bookmark. 

Insert two buttons into the report, turn on their action and set their action type to bookmark. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!