Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
marshala
New Member

Slicer on unrelated tables

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.