Create a visual for a table

[Diplodicus]

I would like a visual (clustered column chart) that shows the average values for each column in a table.

example table:

When I throw all of the columns in the Y-axis of the 'Clustered Column Chart' visual and leave the X-axis empty, it does what I want, but all the columns are clustered in the middle and unlabeled:

Is there a fix for this or a better way to approach the problem? I haven't seen anything about this problem in the research I have done, so any help is appreciated. 

[MasonMA · Accepted solution]

Hi, 

If you are in Power BI, click 'Transform data' and go to Power Query. There you can use 'Unpivot other columns' to unpivot 'id' and 'name' columns before loading data back into Power BI again. 

Then in Power BI, set up your visual this way. 

[Diplodicus]

Perfect, Thanks! A bit of a roundabout process, but it works. Also, I should note that when I selected the 'id' and 'name' columns and clicked 'Unpivot other columns', while the operation did work, it caused the primary key column to fill with duplicates. In order to address the new issue, I went to 'Add Column' > 'Index Column' > 'From 1' to add a new column for primary keys before clicking 'Close & Apply'.