Dynamic Column Display in Power BI Based on Slicer Selections

[Anonymous]

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 

[Anonymous · Accepted solution]

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.