Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I'm new to Power BI and I would like your help regarding a graph I would like to build. In an excel table I have more than 50 records of data that are created throughout time. All of these records are categorised based on 5 different issue type (problem, incident, service request, monitoring, chnage) and I want to create a graph line that show the overall number of created within the last 7 days and number of Done with the last 7 days. For the moment I need just a total number (regardless of issue type). For example: On the 26th are created 7 records (of all issue type) and there are Done 2 (of all type).
Kind Regards,
Shpendi
Solved! Go to Solution.
Hi @Shpendi
You might refer to these similar threads for reference:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
https://community.powerbi.com/t5/Desktop/Count-of-Open-cases-over-time/td-p/761764
https://community.powerbi.com/t5/Desktop/Getting-a-running-total-of-current-open-Tickets/td-p/448431
Hi @Shpendi
You might refer to these similar threads for reference:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
https://community.powerbi.com/t5/Desktop/Count-of-Open-cases-over-time/td-p/761764
https://community.powerbi.com/t5/Desktop/Getting-a-running-total-of-current-open-Tickets/td-p/448431
Thank you for your help!
Hi @Shpendi
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |