Use slicers to display different tables dynamically

[RamyaRapolu]

Hello,

I have 3 tables TableA, TableB and TableC and a static table with values A,B,C. I want to display TableA when A is selected in slicer and TableB when B is selected. All the tables have different number of columns but have one coulmn in common called CreateDate which should be changed in slicer based on the table displayed . Could someone help?

[v-luwang-msft · Accepted solution]

Hi @RamyaRapolu ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it. 

Best Regards

Lucien

[v-luwang-msft]

Hi  @RamyaRapolu ,

As far as I know, it is not possible to do it any other way than bookmark. If it needs to be implemented by a slicer, it needs to be consistent across all table structures to work.

Best Regards

Lucien

[themistoklis]

Hello @RamyaRapolu ,

Have you tried using this Bookmarks?

This will probably solve your issue.

https://www.youtube.com/watch?v=FBEF1xMxxEE

[RamyaRapolu]

Thanks for the reply @themistoklis 

I have tried that but I have around 20 tables. Is that the only way?.