Forum Discussion

Kbutcher's avatar
Kbutcher
Regular Visitor
8 years ago
Solved

Power BI Line Chart

Hi,    I am trying to create a line chart on Power PI using historical figures.  Due to how the information is used, for this historical aspect I am working with as follows:    Month            F...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Kbutcher,

     

    Please first unpivot table structure in Query Edit mode.

     

    Then, add 'Month' field into X-axis of line chart, add 'Figures' into legend.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Kbutcher,

 

Please first unpivot table structure in Query Edit mode.

 

Then, add 'Month' field into X-axis of line chart, add 'Figures' into legend.

 

Best regards,

Yuliana Gu