Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, fairly new with Power BI here.
I am currently trying to create a report that shows me the number of tickets created every month, the last 13 months. I need to group by Priority and month, something like this:
| January 2023 | February 2023 | March 2023 | April 2023 | |
| High | 10 | 6 | ||
| Medium | 5 | 8 | ||
| Low | 28 | 32 |
This is based on data extracted from set JQL and fetched as excelfile and uploaded into Power BI.
Solved! Go to Solution.
1. Create (countrow measure)
2. Create date table
3. Create matrix table
If sample excel is with me, I can share back to you the power bi file
1. Create (countrow measure)
2. Create date table
3. Create matrix table
If sample excel is with me, I can share back to you the power bi file
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 124 | |
| 101 | |
| 67 | |
| 49 |