Forum Discussion
Need Help in creating a simple Report
Hi Guys,
I am new to Power BI, I need to help in creating a report using below data in Power BI. Can you please guide me how can I create such report.
Report Should be like this :
Show the count of Total Issue Assignee , then Issue Resolved Per Quarter, last column for Open issue left : Sum(Q1,Q2,Q3,Q4) - Total Issue Assigned.
| Assignee | Total Issue Assigned | Resolved Per Quarter Q4-2023 | Q1-2024 | Open |
| Merry | 2 | 1 | 1 | |
| John | 6 | 1 | 2 | 3 |
| Riswan I | 8 | 1 | 7 | |
| Vikrant Yadav | 4 | 2 | 2 | |
| Sabarimani Ramamoorthi | 2 | 2 |
| Issue key | Summary | Created | Updated | Assignee | Resolution | Resolved |
| ABC-5619 | Creating new PowerBI dashboard for Zoom App | 5/29/2024 12:39 | 5/29/2024 12:39 | Merry | ||
| ABC-5610 | To Create New Records in Snipe IT Based on the Invoice | 5/28/2024 15:15 | 5/28/2024 15:15 | John | Done | 5/28/2024 15:15 |
| ABC-5609 | Status Transition for Security Issue Type to be added | 5/28/2024 13:20 | 5/28/2024 15:11 | Riswan I | ||
| ABC-5608 | Automate Jira and Confluence Cleanup Activity | 5/28/2024 12:21 | 5/28/2024 12:27 | Vikrant Yadav | ||
| ABC-5607 | Serial number missing on the invoice | 5/27/2024 18:12 | 5/27/2024 18:13 | Riswan I | ||
| ABC-5606 | Cleanup of the To recycle status with active user | 5/27/2024 16:47 | 5/27/2024 16:48 | Riswan I | ||
| ABC-5605 | User active legacy status cleanup | 5/27/2024 16:46 | 5/27/2024 16:46 | Riswan I | ||
| ABC-5604 | Documentation and implementation of the New Asset Onboarding in Snipe IT | 5/27/2024 15:09 | 5/27/2024 15:14 | John | ||
| ABC-5603 | Documentation and implementation of the Laptop Gifting | 5/27/2024 14:58 | 5/27/2024 15:44 | Riswan I | ||
| ABC-5602 | Documentation and implementation of the Asset replacement process | 5/27/2024 14:55 | 5/27/2024 15:44 | Riswan I | ||
| ABC-5601 | Ticket #1173476 Create app registration for VOIP monitor | 5/27/2024 14:29 | 5/27/2024 14:30 | Sabarimani Ramamoorthi | ||
| ABC-5600 | Adding Zoom Reports on the Collabs tools | 5/27/2024 12:09 | 5/27/2024 12:09 | Riswan I | ||
| ABC-5575 | Zero Junk Email Initiative - CTO DL List | 5/24/2024 17:02 | 5/24/2024 17:04 | Sabarimani Ramamoorthi | ||
| ABC-5572 | fixVersion 19.8 | 5/23/2024 15:49 | 5/27/2024 10:14 | Vikrant Yadav | Fixed | 5/23/2024 16:35 |
| ABC-5571 | Asset Wipe Confirmation | 5/23/2024 13:17 | 5/23/2024 13:18 | John | Done | 5/23/2024 13:18 |
| ABC-5570 | To Create New Records in Snipe IT Based on the Invoice | 5/23/2024 12:54 | 5/23/2024 13:13 | John | Done | 5/23/2024 13:13 |
| ABC-5566 | Zephyr Test Cases Fields | 5/22/2024 21:10 | 5/27/2024 12:25 | Vikrant Yadav | ||
| ABC-5564 | Slack KT | 5/22/2024 20:20 | 5/22/2024 20:49 | John | ||
| ABC-5563 | Reports For ITAM | 5/22/2024 20:19 | 5/24/2024 21:42 | John | ||
| ABC-5557 | Creating new Lucid chart powerbi Dashboard | 5/22/2024 12:18 | 5/28/2024 12:42 | Merry | Done | 5/28/2024 12:42 |
| ABC-5556 | New Custom Field: UI Story Points | 5/22/2024 10:16 | 5/27/2024 10:15 | Vikrant Yadav | Fixed | 5/23/2024 13:38 |
| ABC-5548 | Create the new snipe IT status To Loan (Location) | 5/21/2024 20:23 | 5/22/2024 21:03 | Riswan I | Fixed | 5/22/2024 21:03 |
Hi, vikrantyadav11
In fact, rajendraongole1 was gave the correct Measure and you can use these Measure in the steps below.Or you can try the following measure
Resolved Q2 2024 = CALCULATE ( COUNTROWS ( Issue ), FILTER ( 'Issue', 'Issue'[Resolved] >= DATE ( 2024, 4, 1 ) && 'Issue'[Resolved] <= DATE ( 2024, 7, 31 ) ) )Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
3 Replies
Hi vikrantyadav11 - You can achieve this by using table/matrix visualization with some measures that need to create as below:
Measure 1:
Total Issue Assigned = COUNTROWS('Issue Data')
Measure 2:
Resolved Q1 = CALCULATE(COUNTROWS('Issue Data'), 'Issue Data'[Resolved] >= DATE(2024, 1, 1) && 'Issue Data'[Resolved] < DATE(2024, 4, 1))
similarly, you can create measures for Q2, Q3, and Q4.
Measure 3:
Open Issue Left
Open Q1 = [Total Issue Assigned] - [Resolved Q1]
you can create a Power BI report that shows the count of total issues assigned, issues resolved per quarter, and open issues left per quarter for each assignee
FYR: Microsoft Power BI Learning resources :
Power BI Learning Resources – Data Analytic Group
Please go through the above link to find more about learning resources
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Hi rajendraongole1 Thanks for your response!
I have Power BI online. I am not sure where to write to these measures. So sorry asking such basic question.
Can we connect over linkedin?
Hi, vikrantyadav11
In fact, rajendraongole1 was gave the correct Measure and you can use these Measure in the steps below.Or you can try the following measure
Resolved Q2 2024 = CALCULATE ( COUNTROWS ( Issue ), FILTER ( 'Issue', 'Issue'[Resolved] >= DATE ( 2024, 4, 1 ) && 'Issue'[Resolved] <= DATE ( 2024, 7, 31 ) ) )Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
