March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
22 | |
21 | |
10 | |
10 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |