How to make filter to all tables in Dashboard

[savanah]

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 !

[GilbertQ · Accepted solution]

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

[savanah]

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 

[Mond]

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.