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.

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!

 

 

 

 

PaulDBrown's avatar
PaulDBrown
Community Champion
8 years ago

Anonymous

 

 

You create the link for each image (it has to be an image; text boxes don’t have the option to link to bookmarks) to the corresponding bookmark in the Format Image pane. Select the image/button which will act as the “slicer”/selection and open the image format pane. Apologies since this screenshot is actually from the PBI service, but it’s the same on Desktop.

 

There is no toggling option. Each image is referenced to individual bookmarks where you have pre-set the visuals to be seen (by hiding the visuals not wanted for that “slicer”/selection in the selection pane) when the user clicks on the image

 

Sorry about the poor explanation:I’m typing this on an ipad....

 

let me know if you are still having problems.

 

Regards,

Paul..