Relationships Not Working

[Anonymous]

Hi,

I created a separate table with the same values as two other tables in my dashboard but they won't connect and i am not sure why.

Column 1 contains the same values as customer in 3 of the other tables.

Kind regards

Dominic

[v-jiascu-msft]

All the shared variables (columns) are in one table? I'm afraid it won't work like that. We have to separate them by the property. One dimension only has one topic. 

If the table only contains unique customers, it's easy to create a relationship. Please refer to the snapshot below.

Best Regards,

Dale

[v-jiascu-msft]

Hi @Anonymous,

Maybe you need to establish relationships manually. It can be created automatically. But the "auto relationship" can't detect the relationships all the time.

Best Regards,

Dale

[Anonymous]

Thanks Dale, but I am not sure how to do this?

Kind regards

Dominic

[v-jiascu-msft]

Hi Dominic,

1. You can drag the field from one table to the other table with the left button of the Mouse.

2. You also can follow the function "Manage Relationships".

Best Regards,

Dale

[Christann]

Have you tried creating the relationship manually? If so could you send a screen shot of the error you are getting?