Stock Movement graph

[eagletro]

Hi,

i am trying to graph the below. i  just want each year as a line showing the values for the item number 23670030 by month.

i can achieve the below in excel.. each series is a year.. sorry rushed it 🙂

but the best i can achieve in power bi so far is..

any help will greatly appreciated.

Robert

[v-ljerr-msft · Accepted solution]

Hi @eagletro,

According to your description above, you may need to use Unpivot option under Query Editor > Transform to unpivot your "JAN", "FEB" ... "DEC" columns to a column with all months, and a column with all values of each month. 

Then you should be able to use the unpivoted Month column as Axis, the YEAR column as Legend, and the Value column as Values on the Line chart to get your expected result.

For more details about how use Unpivot option with Power BI, you can refer to this article. 

Regards

[prakash_gautam]

Hello,

What about Year in Legend, Month in Axis and the measure in Values as in the following screen:

Thanks,