Trouble Duplicating Line Chart From Excel In Power BI

[kitcatnj]

Hello. Relatively new here. I THOUGHT i understood how to create a chart. For some reason, no matter what combination I try, I can't seem to correctly re-create the line chart from Excel in Power BI. 

First image is the excel data I am bring in and the line chart I am supposed to duplicate. 

The 2nd are the results I am getting back along with the data. 

What am i doing wrong? I have tried changing x and y axis data, legend data. It seems like the simplist thing to do but It just doesnt work for me. 

For anyone trying to duplicate what I am doining, here is the data.

Food	Jan '22	Feb '22	Mar '22	Apr '22	May '22	Jun '22	Jul '22	Aug '22	Sep '22	Oct '22	Nov'22	Dec'22	Avg
Rice	474	484	964	810	670	562	458	346	303	333	201	77	474
Beans	164	165	303	203	78	148	221	136	122	156	74	20	149
Tortillas	41	57	182	246	95	181	244	164	87	108	99	40	129

[kitcatnj]

AMAZING! I did try to pivot originally, but i did it on all the columns and it didnt do much for me. I didnt know you could keep on column selected and pivot the rest. It worked PEFECTLY!!!! Thank you so so much!

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[grantsamborn · Accepted solution]

Unpivotting your table in Power Query is the key step.

Follow these steps:

In Power Query
- select Food column and unpivot other columns
- fix up the period and convert it to a date

Create and configure Date table.

Line chart with:
- x-axis: MMM-YY
- y-axis: [Sales] measure
- Legend: [Food] column

pbix: https://1drv.ms/u/s!AnF6rI36HAVkhPIi3NykR9olljC9sw?e=n6zGcI

Let me know if this helps.