table relationship issue

[vjnvinod]

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.

[gooranga1]

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]

@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]

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

[v-piga-msft]

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

[vjnvinod]

@v-piga-msft

power BI doesn't allows to change the direction to both.

Data is confidential, so wondering how to share it

[vjnvinod]

@v-piga-msft

here is the file you requested for, have a look, i noticed that my outbound values is not interacting with the 3rd table(unformatted table in the pbix)

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