Line Chart Help

[TAD80]

Hi,  

I'm looking for help creating a line chart from a table like the sample below. I want the months to be on the x axis and a trend line for each of the KPI's. I'm not sure if this is possible because I have the months in the columns and not rows, I just can't get it to work. Does anyone know if this is possible? Any help much appreciated. 

[Kedar_Pande · Accepted solution]

@TAD80 

• Click on Transform Data to open the Power Query Editor.
• In the Power Query Editor, select all the month columns (July to December).
• With the month columns selected, right-click and choose Unpivot Columns. This action will convert the months from columns into rows.
• After unpivoting, you will have two new columns: Attribute (which holds the month names) and Value (which contains the KPI values).
  Consider renaming these columns to Month and KPI Value for clarity.
• Click on Close & Apply to load the transformed data back into Power BI.
• Now create a line chart

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[TAD80]

Thanks Kedar! That exactly what I needed.

[lbendlin]

This table format is typical of Excel.  Unpivot the data to bring it in a usable format for Power BI.