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.

 

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.

     

    "Toggling" Visuals

     

    Hope it helps!

     

    Regards,

    Paul.

5 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community 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.

    • Anonymous's avatar
      Anonymous
      Not 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!

       

       

       

       

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion

        Anonymous

         

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

         

        "Toggling" Visuals

         

        Hope it helps!

         

        Regards,

        Paul.