exhibit same variable several times?

[Anonymous]

Newbie here. I have a column named category which contains 5 variables (M1 - M2- M3 - M4- M5). For each variable, the amount is collected since 2018 on a monthly basis. What I am trying to do is to present each variable at a time in a line chart on a monthly basis: so what I want to showfor example,  is 3 lines of M1 (M1 2018 - M1 2019 - M1 2020) with y amount in USD and x is the months (1 to 12). Help please? 🙂

d_categ	Year	Month	Avg_amount
M1	2019	1	2241
M1	2019	2	2401
M1	2019	3	2731
M1	2019	4	2722
M1	2019	5	2383
M1	2019	6	2283
M1	2019	7	2335
M1	2019	8	2552
M1	2019	9	2423
M1	2019	10	2362
M1	2019	11	350
M1	2019	12	3957
M1	2020	1	2239
M1	2020	2	2658
M1	2020	3	2681
M1	2020	4	3278
M1	2020	5	2932
M1	2020	6	2484
M2	2020	1	3493
M2	2020	2	1211
M2	2020	3	3940
M2	2020	4	0
M2	2020	5	0
M2	2019	1	877
M2	2019	2	359
M2	2019	3	8264
M2	2019	4	1034
M2	2019	5	3938
M2	2019	6	9630
M2	2019	7	0
M2	2019	8	4012
M2	2019	9	8832
M2	2019	10	1231
M2	2019	11	1616
M2	2019	12	1275
M2	2020	1	6400
M2	2020	2	3405
M2	2020	3	8843
M2	2020	4	1154
M2	2020	5	1200
M2	2020	6	5006
M3	2019	1	3188
M3	2019	2	3916
M3	2019	3	5869
M3	2019	4	2596
M3	2019	5	2234
M3	2019	6	7875
M3	2019	7	2472
M3	2019	8	7537
M3	2019	9	2941
M3	2019	10	3577
M3	2019	11	4250
M3	2019	12	8869
M3	2020	1	4210
M3	2020	2	9248
M3	2020	3	3418
M3	2020	4	7651
M3	2020	5	2069
M3	2020	6	3319

[Anonymous]

Hi @Anonymous ,

How about creating a calculated table as below and use it as legend in line chart?

Best Regards,

Jay

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?

Year as axis and category as legend or vice versa.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

[Anonymous]

Thank you @amitchandak  for your reply. I've added a table with a sample dataset.

Thanks again