Forum Discussion

dbalaciano's avatar
dbalaciano
Regular Visitor
9 years ago
Solved

Graph based on values in different columns

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 co...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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. :smileyhappy:

     

    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's avatar
dbalaciano
Regular Visitor
9 years ago

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's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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. :smileyhappy:

 

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's avatar
    dbalaciano
    Regular Visitor
    9 years ago

    That worked perfectly!

    Thank you for your help.