Power BI Line Chart

[Kbutcher]

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            Figures 1              Figures 2               Figures 3              Figures 4             

Jan                   x                           x                             x                            x 

Feb                   x                           x                            x                             x 

Mar                  x                            x                           x                              x

And so on... 

So I am looking for a line chart that plots each figures across the months.  Is there a way to make this possible?

Thanks for any help.

[v-yulgu-msft · Accepted solution]

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