LINE AND STACKED COLUMN CHART

[Julier]

Im trying to create this visual, however the S&OP figure is a changing figure each month but it will only show it as a sum, it wont let me show it without summing it, the data is in 2 tables, i have been trying all different ways to show the data correctly in this kind of chart but with no luck, hope someone can help me please

[Anonymous]

Hi @Julier ,
If you want to display values in different tables without summing. You need to establish a relationship between the two tables.
Sample data
Monthly Sales

S&OP

Relationship

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Julier]

Thank you, howver i am unable to get a one to one relationship 

[Anonymous]

Hi @Julier ,

Thank you for your reply, the issue is due to the fact that you have duplicates in your data and the model is unable to create a relationship on that. You can create relationships with non-duplicated primary keys, for example you can create relationships based on event ids (non-duplicated)

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Julier]

Thank you, i have had to total my daily sales into a monthly figure using a measure and plotted this into the graph, the S&OP figure is a also monthly figure but i cannot link these, i have provided the sample data which i have then amended in the query to give me these two tables which i cannot build any workable relationship 

The first table is the sample S&OP and the second table is the sample sales by day which i have then totalled using a measure.

Site	Cluster	ERP ID*	Customer Name	Customer Group	New Category	M2S Classification	FM ID	May-24	Jun-24	Jul-24
north	North	3219/0	aaaaaaa	aaaaaaa	xx			8,205	8,000	8,000
north	North	1963/0	bbbbbb	bbbbbb	yy			7,907	7,907	10,900
north west	North	600070	ccccccc	ccccccc	xx			26,130	31,816	16,784
north west	North	600006	ddddd	ddddd	xx			67,000	67,000	76,000
north west	North	600002	eeeee	eeeee	zz			45,000	45,000	55,000
north west	North	600001	fffffff	fffffff	xx			32,000	32,500	8,238
north west	North	600082	ggggg	ggggg	xx			450,000	450,000	400,000
south	North	600015	hhhhh	hhhhh	yy			48,620	44,453	48,660
south	North	600054	iiiiiiiii	iiiiiiiii	yy			250,000	250,000	200,000
south	North	600073	jjjjjjjj	jjjjjjjj	xx			380,000	385,000	400,000
south	North	17316/0	kkkkk	kkkkk	xx			310,000	400,000	5,000
south	North	3219/0	llllllll.	llllllll.	zz			45,500	40,470	55,617

Plant Name	Customer	Plant Customer ERP ID	Ship To Customer Id ERP	Product Code	Volume (SQM)	Selling Plant	Ship-To Customer Name	Date Short	Calendar Month Name	Calendar Year
north	aaaaaaa	3219/0			905		aaaaaaa	18/05/2024	May	2024
north	bbbbbb	14667/0			1,599		bbbbbb	19/05/2024	May	2024
north west	ccccccc	14667/0			1,936		ccccccc	20/04/2024	April	2024
north west	ddddd	14667/0			2,570		ddddd	21/06/2024	June	2024
north west	eeeee	14667/0			6,746		eeeee	22/05/2024	May	2024
north west	fffffff	14667/0			1,002		fffffff	23/04/2024	April	2024
north west	ggggg	14667/0			4,724		ggggg	24/05/2024	May	2024
south	hhhhh	14667/0			944		hhhhh	25/05/2024	May	2024
south	iiiiiiiii	14667/0			3,488		iiiiiiiii	26/04/2024	April	2024
south	jjjjjjjj	1968/0			3,171		jjjjjjjj	27/05/2024	May	2024
south	kkkkk	1968/0			8,262		kkkkk	28/06/2024	June	2024
south	llllllll.	1968/0			4,721		llllllll.	29/05/2024	May	2024

[lbendlin]

You posted this in the Power Query forum?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...