Forum Discussion
Add/Remove columns to table based on slicer selection.
Hi,
I have 20 columns in data table. And one of the columns contains values which can be used for slicer, total distinct values for Slicer are 3. So i have 3 values that i can select from slicer.
Number of columns that needs to be displayed in table visual for each slicer is varying.
For first slicer i need to show 15 columns in table visual, For second slicer I will need to add few columns to table and remove few. Same with third slicer need to add few and remove few.
I created three book marks for this, but we need to achieve in one single page of Power BI.
Any sugesstions or references will help.
Thanks!
Anonymous
Here is a quick and dirty mockup PBIX file which includes the "toggling" of visuals.
Hope it helps!
Regards,
Paul.
5 Replies
- PaulDBrownCommunity Champion
Hi Anonymous,
You can use "buttons" instead of a slicer, one for each of the values you would use in the slicer. Create 3 different visuals (adding/removing colums) and hide/show each visual in the visuals pane by linking each corresponding button per bookmark. All on the same page.
Hope that doesn't sound too confusing...
Regards,
Paul.
- AnonymousNot applicable
Hi PaulDBrown,
Can you also please guide me in linking the text box to a bookmark? I coulnt find any togglign action thing available.
Any refrence link should help.
Thanks!
- PaulDBrownCommunity Champion
Anonymous
Here is a quick and dirty mockup PBIX file which includes the "toggling" of visuals.
Hope it helps!
Regards,
Paul.