How to create Clustered Column Chart grouped by month and person

[kala2]

I'm trying to create a clustered column chart that would show a sum of values, by month for each person with each cluster representing the same month. The data that are in the following format:



I need to create something like this:

Each bar is a person with a sum for the specific month. The person is appearing multiple times in the table for each month so we need a sum for each month.

I've managed in power bi to create a chart grouped by person and month, but i need the opposite as explained above:

Any ideas how to implement the chart?

[mahoneypat · Accepted solution]

You should unpivot your columns for each month in the query editor.  Then you can use the Month column on your x axis and the Person column as the legend to get your result.

Pat

[kala2]

I have unpivoted all dates columns and separated dates and values as shown below:

But sum is not applied for each person in Values axis

[amitchandak]

@kala2 , Month as axis and Person as legend.

Month and person as axis. Sort on Month, person and use concatenate label off , if needed again sort on Month, person

For the second option, you can watch the power bi part here

https://www.youtube.com/watch?v=2P5BBRN853c