Dynamically select columns in Table based on slicer selection

[AleSota]

Hi everyone! 

I'm searching for ways in which I can dynamically select a group of columns and add them to a table based on a slicer selection. I have tried some options but don't work for my case. 

As you see in the image below, I have a quite wide table, and the user wants to see only a subgroup of relevant columns in a table visual, according to what they have identified as relevant for each category. 

Any suggestions are well appreciated!

 

[amitchandak]

@AleSota , Field parameters if you select both columns. Otherwise, you have to use bookmarks

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

Bookmarks

bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive