Problem with a line graph

[Anonymous]

Hi, 
I'm working with a report of sales, but I have a problem with a line graph. I need to switch rows and columns but when I try to do it I got a message that says that a table can't have more than 2200 columns. Of course I won't show all my registers in the graph. I have another page with filters

This is part of my table, and the top of the columns are months and years of the sales.

This is how I want to look my graph

And this is what I got

So what I need is to give a each product a line instead of giving a period of time a line.

Hope you can help me. 

Thanks

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

In Query Editor mode, unpivot columns to format the table structure as below:

Place [Year_Month] onto X-axis, and place [Product] into legend.

Best regards,

Yuliana Gu

[Anonymous]

Hi
Thank you so mucho for your reply, It has been very helpful.
Now I'm having another problem. When I unpivot the table the column of month/year doesn't respect the order

As you can see. 

And When I create the graph also It doesn't haver order in the axis

You know how I can solve this?

Thank you for your help.