Matrix Count and Bar Graph HELP

[jen8080]

Hello!!

 First: I need some assistance creating a matrix with the data in the table below to show a count of how many migrations occur per project. I tried this in the matrix and turning on row subtotals but it isn't working since each migration has its own column. Is there a calculation for this?

 Second: I need to create a bar graph by month and year (x-axis) with a count of migrations (y-axis)

 Any help is appreciated! 

Projects	Migration 1	Migration 2	Migration 3	Migration 4	Migration 5	Migration 6	Migration 7	Migration 8
Project 1	16-Jun-16	6-Dec-16	8-May-17	8-May-17
Project 2	27-Feb-17	18-Jul-17	8-Nov-17	30-Nov-17	12-Apr-18	21-May-18	21-Dec-18	15-Apr-19
Project 3	7-Jun-16	8-Mar-17	24-Apr-18	18-Oct-21
Project 4	14-Sep-16	24-Jul-17
Project 5	3-Apr-17	21-Jul-17	2-Feb-18	14-Mar-18	8-Aug-19	23-Aug-19	27-Nov-19	26-Jun-20

[v-yalanwu-msft · Accepted solution]

Hi, @jen8080 ;

You could unpivot in power query, we select those column then unpivot.

Then create a  bar graph.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jen8080]

@v-yalanwu-msft thank you so much worked perfect!