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 have the capability to dynamically alter the column display within the table based on their selections in the slicers. For instance, if they select all options, then the resulting table should appear as shown in the provided image.


Conversely, if they opt for only the Year 2023 and Target 1, then the resulting table should look like the second image provided.

 

Could you suggest the most efficient method to accomplish this?
Additionally, if there is a more sophisticated visual available that can fulfill this requirement, even if it is a premium option, that would be acceptable.

Thank you in advance for your assistance.
regards 

Need Help
Tips and Tricks
Tutorial Requests
  • 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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.