Line Chart with Multiple Columns

[Anonymous]

Howdy!

This may be a super simple question to answer all of the PBi guru's out there (I might be searching this forums using the wrong terms) but I am having some difficulty creating a line chart visualization with my data (see image). 

In the image you can see that each column has the data points (month-SI) that I want to plot on the X-Axis and then on the Y-Axis I want to the plotted point to be by the appropriate value value (generally between 1 to 3).

My problem is that the line chart visualization in PBi keeps wanting to put the SKU on the X-Axis instead of the month. How can I adjust this? Thanks in advance! 

[Anonymous · Accepted solution]

I actually figured out my own answer, it was the "shape" of my data that was the problem. 

Since I was only trying to visualize on a line graph with a slicer, I loaded a second table of my base data and unpivoted the columns I needed (the month_sales columns). Then I was able to bring it in and create the line graph!