Forum Discussion
Graph based on values in different columns
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
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. :smileyhappy:
Regards
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
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
That worked perfectly!
Thank you for your help.