Forum Discussion
Filter dimension table visual when selecting in fact table visual
Hey Francisco_G_Cal ,
you can configure which tables is filtered by which other table with the filter direction:
https://radacad.com/what-is-the-direction-of-relationship-in-power-bi
However if you set all relationships to bidirectional you can get results you don't want and a bad performance. Check the article of Nikola Ilic:
The best way is to filter the visuals by a DAX measure. Check the following video, here it's described in detail:
https://www.youtube.com/watch?v=1yv5srlqgmI
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Go to the Model tab and edit the relationship between the two tables.
You should be able to update the cross filter direction for the table relationship to "both", which will accomplish what you want.