Can we make table relationships when products are arranged in separate columns?

%3CLINGO-SUB%20id%3D%22lingo-sub-1484489%22%20slang%3D%22en-US%22%3ECan%20we%20make%20table%20relationships%20when%20products%20are%20arranged%20in%20separate%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484489%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20data%20table%20has%20products%20arranged%20in%20separate%20columns.%3CBR%20%2F%3EI%20have%20made%20another%20table%20listing%20all%20my%20products%20under%20one%20column%20so%20that%20they%20act%20as%20primary%20key.%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20made%20the%20report%2C%20However%20the%20graph%20isn't%20filtering%2C%20based%20on%20different%20products.%3CBR%20%2F%3EDo%20I%20need%20to%20restructure%20my%20data%20or%20making%20the%20relationship%20properly%20would%20do.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20attaching%20the%20screenshots.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1484489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484499%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20we%20make%20table%20relationships%20when%20products%20are%20arranged%20in%20separate%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F523656%22%20target%3D%22_blank%22%3E%40Nishkarsh31%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20that%20Power%20Pivot%20or%20Power%20BI%20Desktop%20model%3F%20Looks%20like%20the%20latest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484564%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20we%20make%20table%20relationships%20when%20products%20are%20arranged%20in%20separate%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484564%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20power%20BI%20desktop%20model.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20suggest%20some%20way%20to%20make%20this%20table%20relationship%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

My data table has products arranged in separate columns.
I have made another table listing all my products under one column so that they act as primary key.

I've made the report, However the graph isn't filtering, based on different products.
Do I need to restructure my data or making the relationship properly would do.

I'm attaching the screenshots.

2 Replies

@Nishkarsh31 

Is that Power Pivot or Power BI Desktop model? Looks like the latest

This is power BI desktop model.

Can you suggest some way to make this table relationship work?