Dynamically Select Table

[Anonymous]

Hi everyone,

I'm hoping what I would like to do is possible and I will do my best to explain it, so here it goes.

I have multiple excel files, all are formatted the exact same way. For example:

File 1 - Bob report.xlsx

Column A	Column B	Column C	Column D	Column E
1	A	a	#	-

File 2 - James report.xlsx

Column A	Column B	Column C	Column D	Column E
2	B	b	$	_

What I would like to do is create a dashboard with various graphs pulling the data from the different columns. How it would work is as follows:

There is a slicer with the names Bob and James. If I select Bob, Bob's data will appear across the graphs. If I select James, James's data will appear across the graphs.

Is dynamically switching between tables and the data from them possible? If so, how would one do that?

Thank you!

[Avantika-Thakur · Accepted solution]

Hi @Anonymous ,

There are multiple ways you can achieve this -
1) By creating Buttons with names of Bob and James and each view will have a repective bookmark with their respective data which will change based on button selection

2) By appending the data tables for Bob and James and having an additional column defining which data is for Bob and which one for James. Then with the click of slicer the data will get replaced within the same visual.

Hope this helps!

Thanks,

Avantika Thakur

[Anonymous]

Hi @Avantika-Thakur,

Thanks for the response. I will give these methods a try.