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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
savanah
Frequent Visitor

How to make filter to all tables in Dashboard

Hi every one !

I have 2 tables (T1 and T2)
In T1 there's a columns (City), Also there's  coulmn (City) in T2 - same value-


there is no Relashionship Between T1 and T2..

Can you please explane to me how I can make Filtering By City in Dashborad To All tabel (T1 and T2)?

Thank you !

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @savanah 

 

What you would need to do is to have a table which has got all your Cities values. You would then create a relationship from T1 and T2 to your City Table.


Then you can use the values from your City table to filter both tables T1 and T2.

 

This is known as a star schema, here are more details: Understand star schema and the importance for Power BI - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @savanah 

 

What you would need to do is to have a table which has got all your Cities values. You would then create a relationship from T1 and T2 to your City Table.


Then you can use the values from your City table to filter both tables T1 and T2.

 

This is known as a star schema, here are more details: Understand star schema and the importance for Power BI - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank you very much for replay  
I was create (cites) table..

but when I make relationships between (citey in T1 or T2) 

the message appears

(you can't create a relationship between these two columns because one of the columns must have unique value 

Hi @savanah ,

 

@GilbertQ asked to create a distinct list of values (Cities) as a dimension table that can be joined to both ends of T1, T2 city columns.

Use City column from new dimension table in your filter criteria.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.