Forum Discussion
Relationships between datasets
Hi, Let's say you have the following datasets: Dataset 1 region country A 1 B 2 C 3 Dataset 2 business unit country BU_A 1 BU_B 2 Relation: single (d...
it is because your single direction relationship is preventing you from filtering on the many side. If you want to filter BU_A then you need to have a filter in both directions and you need to change your relationship to both instead of single - currently you can only filter from the one side, not the many side.
However that can provide confusing results sometimes depending on what you are doing and if you dont understand how power bi works. So make sure you understand how the bi directional relationships work.
Hi Anonymous ,
I agree with vanessafvg statement. If you are still confused, can you provide more detailed requirements or desired results for me to do further testing.
Looking forward to your reply.
Best Regards,
Henry