Forum Discussion
Creating a Created VS Done line graph
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
Hi Anonymous
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
3 Replies
- v-diye-msft
Community Support
Hi Anonymous
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.
- v-diye-msft
Hi Anonymous
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