Forum Discussion

Josemalive's avatar
Josemalive
New Member
6 years ago
Solved

Simple line chart with months in columns

Hi, 

 

I have a data source with the following shape:

 

KPIJANFEBMAR

APR

KPI1565

4

KPI2433

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.

 

Need Help

3 Replies

    • Josemalive's avatar
      Josemalive
      New Member
      6 years ago

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

       

      Really useful.

      Regards.

      Josema.

       

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    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.