Slicer on unrelated tables

[marshala]

Hi

I have  2 charts on a page pulling in data from 2 separate tables that are not related. Both tables have a city, province and country column - how can I create a slicer that filters both charts by city, province and country?

Thanks

[Anonymous · Accepted solution]

HI @marshala

Is it possible to setup the relatonship between the two tables?

If not, Create a bridge table which has the unique id values from both table,and bring oher required columns. Set relationship between the new table and two exisitng table as  1 to many and filter direction is from new table to existing tables. Now you can create slicers for city, country, province from the new table which will filter both visuals.

Thanks
Raj