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:

https://towardsdatascience.com/killing-me-softly-bi-directional-relationships-in-power-bi-b6b0b9e150f4

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