Creating a Created VS Done line graph

[Anonymous]

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

[v-diye-msft · Accepted solution]

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 

https://community.powerbi.com/t5/Desktop/Opened-and-Closed-ticket-count-by-Shift-along-with-Carry-Over/td-p/620421 

[Anonymous]

Thank you for your help!

[v-diye-msft]

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.