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) ?