Forum Discussion
Matrix Count and Bar Graph HELP
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 |
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.
2 Replies
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.v-yalanwu-msft thank you so much worked perfect!
