Forum Discussion

Jackisover's avatar
Jackisover
Icon for Advocate I rankAdvocate I
4 years ago
Solved

My dynamic visual won't work (relations)

Hello everybody,  I had a quick formation in Power BI but not enough for me to understand everything. I've already created a lot of visuals but I have a problem with this one (bottom) : The ...
Need Help
  • Jackisover's avatar
    Jackisover
    4 years ago

    Hello,
    I found my solution. I needed 2 things : 

    - Create a bridging table to have unique type of accomodation keys to create a one to many relation.

    - Make sure my city keys table was setted as well on one to many relation. I don't know why but it wasn't the case, so I recreated this file (file 2) and everything worked fine.

    Thank you vanessafvg for your help

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

the issue is because you have a bidirectional relationship and a many to many relationship - i dont suppose you are able to share the power bi file?  

 

ideally you need to do some remodelling

1. you can do is create a lookup table with all unique city keys and then link all the tables you have to that table.  then you filter on that lookup table.  make sense?

 

 

Jackisover's avatar
Jackisover
Icon for Advocate I rankAdvocate I
4 years ago

Thanks for your answer vanessafvg , I'm not sure I get it.
I sent you a private message with my file.

 

Actually, this is what i wanted to do : file 2 contains only unique city keys, my other tables are related to it. It works perfectly fine if I want to filter on cities, but won't work if I want to filter on type of accomodation. Should I change the relation to file 1 (many) - file 2 (unique) ?