Forum Discussion

eagletro's avatar
eagletro
Frequent Visitor
9 years ago
Solved

Stock Movement graph

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.. so...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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. :smileyhappy:

 

Regards