Forum Discussion

Jackisover's avatar
Jackisover
Advocate 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

Jackisover's avatar
Jackisover
Advocate I
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
Community Champion
4 years ago

so sorry i didn't get back to you just been incredibly busy but very glad you figured it out, well done!