Show different table based on slicer selection

[Anonymous]

Hi,

Say I have two tables that are not connected to each other,

Table A - Column1 Column2 Column3

Table B - Column4 Column5

I also have a slicer, with options Tab1, Tab2

I would like to create a table that shows only Column1 and Column2 from Table A when Tab1 is selected, and only Column4 and Column5 from Table 2 when Tab2 is selected.

I know it is possible to do this using a bookmark by hiding the other visual. I actually have many different tables to show and creating bookmarks would be a tedious option. I was wondering if this can be done with slicers alone

[Jihwan_Kim]

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

Please check the below picture and the sample pbix file's link whether it is what you are looking for.

All measures are in the sample pbix file.

https://www.dropbox.com/s/0ve25voz2e8n8pv/rajesh.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

Hi Jihwan,

Thanks for taking time to answer the question.

I was looking to display a table rather than a graph, like, show a table visual with Customers and Sales on choosing Tab1 and show a table visual with Product and Quantity on choosing Tab2

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Thank you for your feedback.

Please check the link down below, that I amended.

I hope it suits your case.

https://www.dropbox.com/s/0ve25voz2e8n8pv/rajesh.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM