dymanically changing visualisation fields

[BenDenham]

I am currently trying to create a report in PowerBI where there user can select a table (via a Silcer), and then depending on their choice it will show a different set of results in a visualisation.

For example, they click one of the below:

And then a visualisation will change to now be looking at that table. The fields the visualisation will be looking at have the same name in each table, but the overall table schema is different.

Now sure if anyone had any ideas on how to achieve this.

[Habib]

This is possible in Power BI but little tricky. Please refer to below link. It will give you idea on how to build what you are looking for.

http://sqljason.com/2012/11/measure-selection-using-slicers-in.html