Filter dimension table visual when selecting in fact table visual

[Francisco_G_Cal]

Hi

As much as I can see, the filtering in table visuals for one-to-many relations works on direction one-to-many, but not in the inverse direction. I'll explain myself.

• I have two tables (model), a dimension table (or master) and a facts table (or detail), related one-to-many.
• I have created two table visuals, each one showing the fields of each model table.
• When I select a row in the table visual for dimensions, only the related rows in the table visuals for facts are showed. That is the normal behaviour of Power Bi.
• But when I select a row (or rows) in the table visual for facts, the table visuals for dimension is not filtered, showing only the related ones.

Is there any way to achieve this filter 'many-to-one'?

[Francisco_G_Cal]

OMG! That's IT. I've been DAYS struggling with that, tryin a lot of DAX, when this was the PERFECT and SIMPLE solution.

And you answered in a couple of minutes!

Thanks!!! ^_^ 😀

Ah!... I have just watched the video and the article you recommended me and are AMAZING! 👍👍👍

[mattkocak]

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.

[selimovd · Accepted solution]

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-b6b0b9e150...

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