Need help on arranging Tables to create a Graph

[Anonymous]

Hello,

I just want to say thank you from helping me before, I really appreciate it.

Today I got stuck on the following issue.

I have this this table and its setup like these.

Season	Week	Run Date	OS	15	18	21	24	28	32	36	40	44	US
8	52	12/22/2019	188	1665	7210	26825	52223	46401	42050	25098	15476	798	2150
8	52	12/22/2019	188	1817	5243	10445	11288	6830	5144	2824	1727	87	235
8	52	12/22/2019	163	1633	4334	7978	8091	4377	3205	1783	1151	69	221
8	52	12/22/2019	36	336	967	1931	2102	1236	949	551	433	27	84
8	52	12/22/2019	73	569	2144	6619	11460	8960	7807	4582	2810	150	409
8	52	12/22/2019	27	201	1309	7202	20304	22767	24038	14324	7698	331	898
8	52	12/22/2019	419	2325	8192	24977	42447	35853	30377	17532	10433	523	1351
8	52	12/22/2019	82	762	2185	4047	4350	2635	2038	1193	924	69	151
8	52	12/22/2019	1254	9922	25114	45441	41532	20263	11140	4693	2439	123	323
8	52	12/22/2019	39	476	1431	2978	3319	2068	1610	947	707	44	111
8	52	12/22/2019	489	3761	14656	45068	71030	52980	40787	22077	12963	654	1679
8	52	12/22/2019	99	1035	4590	15721	27531	22377	19409	11648	7719	422	1266
8	52	12/22/2019	71	591	1509	2703	2951	1700	1202	601	384	22	53
8	52	12/22/2019	60	547	2001	6818	12538	10734	9939	6187	4278	242	712
8	52	12/22/2019	70	446	1159	2254	2547	1530	1119	555	320	16	38
8	52	12/22/2019	66	442	1786	7995	17142	15630	13984	8523	5565	300	813
8	52	12/22/2019	226	1618	6396	21821	39080	31013	25125	13753	8591	461	1401
8	52	12/22/2019	11	54	297	1881	7199	11159	17474	19401	25861	2600	11790

The problem i have is the chart i want to make is like these. you can see that the X axis have all the sizes(OS,15,18,21,24,28,32,36,40,44,US)

Above graph is in my excel file which i can make simple formula to arrange it the way i want.

The challenge that i have is how to present this on PowerBI, I cant figure out a way to make my X axis have all the (OS,15,18,21,24,28,32,36,40,44,US) since the way my table is setup giving me challenge to arrange it. Appreciate any help.

thanks

Christian

[parry2k · Accepted solution]

@Anonymous you need to unpviot your data. in query editor, select first 3 column,right click, unpivot other columns. you will get attribute and value column.

attribute is the one you will use on x-axis once changes are applied.