Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
TrineHaukedal
New Member

Get COUNT/SUM of data, based on month and priority

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 2023February 2023March 2023April 2023
High106  
Medium 58  
Low2832  

 

This is based on data extracted from set JQL and fetched as excelfile and uploaded into Power BI.

TrineHaukedal_0-1696234674625.png

 

1 ACCEPTED SOLUTION
MinSoeThein_Min
Regular Visitor

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

View solution in original post

1 REPLY 1
MinSoeThein_Min
Regular Visitor

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.