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

what did you click on and what did you expect to change?  when i did it i thought it changed.  ideally the whole thing needs to be remodelled in my opinion

 

before clicking

 

 

 

 

after cllicking

 

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

When you click on one type of accomodation on the top graphic "camping" for instance, i would like the bottom graphic to be filtered, so i only see the yellow bar and not the other types