Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have the below table PlantPerformance and PerformanceTable with SalesOrderID and LineID inside. Inbetween i have two bridge tables made to avoid many to many relationships. Also to avoid inactive relationship, I have given relationships differently as given in below diagram.
Below is the report where I am creating the 1st Donut chart mapping the values from PerformaceTable and below table values are mapped with PlantPerformance table. When I click on the required colors of donut color, the tables are not getting filtered as expected mapping with both the SalesOrderID and Line ID.
How to handle this scenario ?
Solved! Go to Solution.
You may have avoided the M:M relationships but you have created a circular relationship. I am actually suprised Power BI lets you do that. It is probably confused by your bridge tables.
If you need to link tables by multiple fields, use composite keys. If you have to use M:M, use M:M. It's not preferred but also not prohibited. Sometimes it is justified.
You may have avoided the M:M relationships but you have created a circular relationship. I am actually suprised Power BI lets you do that. It is probably confused by your bridge tables.
If you need to link tables by multiple fields, use composite keys. If you have to use M:M, use M:M. It's not preferred but also not prohibited. Sometimes it is justified.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |