Forum Discussion
Can't Relate Two Tables (Pictures Included)
I'm trying to relate two tables: one containing a list of all jobs released for a maintenance company, and another showing stock levels. Not all job categories relate to stock levels, but some relate...
like Anonymous says, you can't have columns on both sides of the relationship with duplicate values. In your list, you could link to the Number column because they are all unique. But can't use Maintenance Category on "1" side of relationship as it has repeated items "White Goods", "Inventory Items"
The top right diagram (from main job list) is unable to interact with bottom right diagram (Stock levels)Showing relationships
Hey danielc7150 - just to confirm you are using the "Maintenance Category" field from the Sheet1 table on all charts, correct? If you could post your pbix file, that would be super helpful!