Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.