Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
48 | |
28 | |
21 | |
19 | |
19 |
User | Count |
---|---|
51 | |
47 | |
25 | |
23 | |
20 |