Hi All, I'm new to PBI and really struggling with what I thought would be a simple graph. I am trying to create a clustered column that shows a count of Projects by stage over months. e.g. Total projects in Demand for April = 20 and May = 18 etc. I thought I would just added the next month to the axis but this then creates a drill down not a side by side comparison?? Below is an example of the table I am using. Any help will be hugely appreciated!
Project ID Apr-19 May-19
| PMO000001 | Cancelled | Cancelled |
| PMO000002 | Implement | Cancelled |
| PMO000002 - A | Pipeline | Pipeline |
| PMO000005 | Implement | Implement |
| PMO000010 | Pipeline | Cancelled |
| PMO000011 | Implement | Implement |
| PMO000012 | Implement | Implement |
| PMO000026 | Cancelled | Cancelled |
| PMO000028 | Plan | Define |
| PMO000029 | Implement | Implement |
| PMO000037 | Cancelled | Cancelled |
| PMO000038 | Implement | Implement |
| PMO000043 | Close | Close |
