Graph based on values in different columns

[dbalaciano]

I have a data table with columns of data for each different month.

And I need to get a graph showing the evolution of the Values in time, showng the average value of the corresponding column for each month. Something like this:

I just can't find a way to build the graph. Even tried to buid additional tables. Can someone help me with some information on how to get it?

Thanks in advance,

[Anonymous]

Thanks for your help with the other solutions, but I can't make it work with that because I have all 12 months but my list of projects tends to infinity. The values for each month are in different columns. Below is a simplification of my data structure and the graph I need to obtain showing the sum per group each month. Please ignore the blue line. 

When I use the solution proposed above of selecting all months and clicking on unpivot (mi data is being extracted from a live shepoint list), it says "error" on every cell of the columns. 

Is there any other solution? 

Regards,

[v-ljerr-msft]

Hi @dbalaciano,

According to your description above, you should be able to use the Line Chart visual with your Month column as Axis, and the corresponding column as Value with aggregation of Average.

If it doesn't work in your scenario, could you post your real table structures with some sample data, so that we can better assistant on it? It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[dbalaciano]

Thanks for your help, but I can't make it work like that because I don't have a month column. I have the values for each month in different columns. Below is a simplification of my data structure and the graph I need to obtain showing the average per group each month. It seems simple, but I just can't find a way to use different columns as X axis in the graph.

Regards,

Diego

[v-ljerr-msft · Accepted solution]

Hi @dbalaciano,

In your scenario, you can use the Unpivot Columns options under Query Editor > Transform tab to get a Month column and a Value column. 

In the Query Editor

1) select the all the month(JAN, FEB, etc) Columns.

2) Transform tab -  Unpivot Columns

3) Rename the Attribute and Values columns - Month and Percentage.

Regards

[dbalaciano]

That worked perfectly!

Thank you for your help.