Simple line chart with months in columns

[Josemalive]

Hi, 

I have a data source with the following shape:

KPI	JAN	FEB	MAR	APR
KPI1	5	6	5	4
KPI2	4	3	3	1

Im trying to create a Line chart showing the evolution of the KPI along the different months with a filter on KPI Name but I'm not succeeding on put the months in the X axis and values in the Y axis.

Here the current configuration that I have but I dont get a line chart but a chart with dots instead line for the selected KPI.

Could you tell me how I can set the months in the X axis so the graph will show a line with the evolution depending on the KPI chosen on the filter section?

Thanks.

Regards.

Jose.

[MFelix]

Hi @Josemalive ,

You to go to the query editor select the columns of the months and then unpivot them.

You can also choose the KPI column and unpivot all other, that way if your columns grow in months those new columns will also be unpivot, if you have more columns that you don't want to be unpivot also selected them alongside with KPI.

You will get 3 columns KPI / Attribute (month) / value then use the Attritbute as you x-axis, KPI on Legend and value on values

Check PBIX file attach.

[amitchandak · Accepted solution]

@Josemalive ,

Better you unpivot the data and then work on it

https://radacad.com/pivot-and-unpivot-with-power-bi

[Josemalive]

Thanks a lot, I didnt know that Query "pipeline" was possible to tweak.

Really useful.

Regards.

Josema.