Power BI Line Chart

Question

Hi,&nbsp;&nbsp;I am trying to create a line chart on Power PI using historical figures.&nbsp; Due to how the information is used, for this historical aspect I am working with as follows:&nbsp;&nbsp;Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Figures 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Figures 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Figures 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Figures 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp;Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp;Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xAnd so on...&nbsp;&nbsp;So I am looking for a line chart that plots each figures across the months.&nbsp; Is there a way to make this possible?&nbsp;Thanks for any help.

v-yulgu-msft · Accepted Answer

Hi&nbsp;Kbutcher,
&nbsp;
Please first unpivot table structure in Query Edit mode.

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

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

Power BI Line Chart

1 Reply

Related content

Line chart

Single Date for line chart in Power BI

Time Line Chart

Previous Year Measure for Line Chart

Forecast in Line Chart