Forum Discussion
Line Chart with Multiple Columns
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!
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!
1 Reply
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!