Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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....
General Comment
  • PaulDBrown's avatar
    PaulDBrown
    8 years ago

    Anonymous

     

    Here is a quick and dirty mockup PBIX file which includes the "toggling" of visuals.

     

    "Toggling" Visuals

     

    Hope it helps!

     

    Regards,

    Paul.

PaulDBrown's avatar
PaulDBrown
Community Champion
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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!