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.. sorry rushed it :)

 

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

 

 

any help will greatly appreciated.

 

Robert

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

2 Replies

  • 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

  • prakash_gautam's avatar
    prakash_gautam
    Resolver II
    9 years ago

    Hello,

     

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

     

    Thanks,