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.
Hi,
I have a page-level filter which is coming from one table(table1) , i've a visual (single column) in which the data is coming from another table (table2).
Now if i check a value in the filter, the visual is not responding as there's no direct relationship between them
But both the tables (table1, table2) have a relationship with another table (table3) on datekey column.
How to achieve this functionality? Early response is highly appreciated.
Thanks,
Swaroop
Solved! Go to Solution.
@SwaroopRoyM Are both relationships set up as bi-directional? Setting the relationships to that type may resolve the issue.
Hi @SwaroopRoyM,
In addition, make sure there is no loop(like Table X and Table Y in the following picture) between your table1 and table2 in your table pattern, because cross filtering direction does not work well with this pattern, and can create an ambiguous set of relationships.
Regards
Hi @SwaroopRoyM,
In addition, make sure there is no loop(like Table X and Table Y in the following picture) between your table1 and table2 in your table pattern, because cross filtering direction does not work well with this pattern, and can create an ambiguous set of relationships.
Regards
I'm not able to make the relationship bi-directional. Just to add, i'm pulling the data from Azure SQL.
Thanks,
Swaroop
@SwaroopRoyM Are both relationships set up as bi-directional? Setting the relationships to that type may resolve the issue.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |