Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Column Display in Power BI Based on Slicer Selections

Greetings, I'm currently grappling with a somewhat intricate challenge. My inputs include: Stores Years Targets Years and Targets are being utilized as slicers. I aim for users to hav...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    As far as I concerned, Power BI is now unable to achieve what you need directly. If you want to dynamically change the displayed columns in a table based on slicer selections for Years and Targets, you might consider using the Bookmarks and Buttons feature in Power BI.

    This method involves creating different views (pages or visuals) for each of your desired table states and then using bookmarks to switch between these states based on slicer selections.

    More details: Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.