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 !
Solved! Go to 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
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
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