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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.