Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
7 years ago

table relationship issue

Dear community,

 

I have 2 visual tables in my dashboard,

1) Inbound

2) Outbound

 

when i click on any of the inbound fields, my data dynamically gets changed but when i select any of the outbound field my values in the dashboard doesn't changes.

 

below is how my relationship setup, i have been trying to find an answer for sometime now, any help on this will be highly appreciated.

 

 

 

 

 

6 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi vjnvinod,

     

    What about changing the direction highlight in red to be Both?

     

     

    If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

     

    Best  Regards,

    Cherry

  • gooranga1's avatar
    gooranga1
    Icon for Power Participant rankPower Participant

    You won't be able to join the country table to inbound and outbound with a "both" join. You can only have 1 "both" join.

     

    I would merge inbound and outbound table into 1 table with a flag determining which row was outbound and which was inbound.

     

    Looks from the inbound outbound it would be easy to merge you would just need a flag to indicate inbound and outbound in new merged table.

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual

      gooranga1

       

      thanks

       

      Note,

      inbound and outbound table are same, there is no difference there, i have create this for a reason that inbound values are based on delivery region and outbound values are based on HQ region.

       

      Merging option is not good for 2 reason

      1) my actual file is 9 mb, its doubling the size, making the file as 18mb

      2) merging will create duplicates(as the tables are same)

       

      • vjnvinod's avatar
        vjnvinod
        Icon for Impactful Individual rankImpactful Individual

        Dear community,

         

        I have 2 visual tables in my dashboard,

        1) Inbound

        2) Outbound

         

        when i click on any of the inbound fields, my data dynamically gets changed but when i select any of the outbound field my values in the dashboard doesn't changes.

         

        below is dummy pbix file, i have been trying to find an answer for sometime now, any help on this will be highly appreciated.

         

         

        https://www.dropbox.com/s/xyybg2sl5dx1cvp/Test1.pbix?dl=0