Forum Discussion

jjjtr945's avatar
jjjtr945
Frequent Visitor
3 years ago

Change Table Visual Based on Slicer Selection

Hi,   I am looking to have a slicer that changes the table shown on my report.    For example, when A is selected I want data A to show, B shows data B, C shows data C, etc... All data is in its ...
Need Help
iceparrot's avatar
iceparrot
Icon for Advocate II rankAdvocate II
3 years ago

Hey jjjtr945 ,

I have a basic question: Your slicer enables users to switch between A, B, and C. Are there any other options they can select?

If not the easiest way would be that you duplicate the pages so that you have three pages in the end. Each page with the table which just contains values of A, B, or C. 

Instead of the slicer you then add a page navigation and hide the pages. So if users select the button for B they will be forwarded to page B where they see the table with B data only. 

Another method would be to use bookmarks, create three tables and hide/unhide the tables depending on the selected bookmark. However, if you don't have any other data displayed on the page I would not go for the bookmark selection. 

Let me know if this is already helpful and which option you prefer more. I can give you more details as well to each solution. 

jjjtr945's avatar
jjjtr945
Frequent Visitor
3 years ago

 iceparrot I have considered using different pages but for my purpose I would prefer to have it all on one page.

 

Would you be able to give more details for each solution? Thank you!