Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show/hide overlapping table visual based on slicer selection

Hello Community,  I have 4 table visuals (possibly more in the future) on top of each other (overlapped): all have different sets of columns coming from the same table. We can consider all the diffe...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,

    Thanks for the solution davidding  offered, and i want to offer some more information for user to refer to.

    hello Anonymous , you can see the following steps to set the bookmards.

    1.Create 4 table visuals, and put the related fields to the table visuals, then open the selection in View option.

     

    2.Name the table visuals as "BU1, BU2, BU3, BU4" in the selection. then put them to the same position.

    3.Then for the first bookmark BU1, we need to display BU1 table visual, and hide the other three table visuals.

    Then set it as a bookmark and name it BU1

    Then for the bookmark BU2, we need to display the bu2 table visual, and hide other three table visuals.

    Then add the page as a bookmark and name it BU2.

    Then refer to the steps above to set the bookmark BU3 and BU4.

    After setting them done, in 'Insert' option, select buttons->navigator->bookmark navigator.

    Output

     

     

     

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Thanks for the solution davidding  offered, and i want to offer some more information for user to refer to.

hello Anonymous , you can see the following steps to set the bookmards.

1.Create 4 table visuals, and put the related fields to the table visuals, then open the selection in View option.

 

2.Name the table visuals as "BU1, BU2, BU3, BU4" in the selection. then put them to the same position.

3.Then for the first bookmark BU1, we need to display BU1 table visual, and hide the other three table visuals.

Then set it as a bookmark and name it BU1

Then for the bookmark BU2, we need to display the bu2 table visual, and hide other three table visuals.

Then add the page as a bookmark and name it BU2.

Then refer to the steps above to set the bookmark BU3 and BU4.

After setting them done, in 'Insert' option, select buttons->navigator->bookmark navigator.

Output

 

 

 

 

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the detailed explanation.

     

    However, it seems the bookmark solution will not work out in this scenario as I will have few other filters on the page so the slicer 1 (in my example above) would change it's value (based on other filters applied on the page) and in some cases it may show only 'BU1' and 'BU2' or any other combination! How would that works out with bookmark solution?

     

    It would be appreciated if you could provide detailed explanation as you did previously.

     

    Thank you,

    Brij