Forum Discussion
Time Line Graph Open vs Closed Tickets
What you have done seems right. Use the Date from the calendar on the chart.
Also, please refer to the solution for a similar problem: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Thanks - This is one of the solutions I had looked at, but still no luck. Ill continue to try and get it to work
Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970amitchandak Thanks - I have uploaded the sample file here:
https://drive.google.com/open?id=1nCka3Uvqxm_Qo7zi-B-03ZyAINWlUUEP
The types of charts I am expecting to create is something similar to:
Time Graph - Id like to be able to distinguish the assigned teams or the assigned owners.
Id like to be able to see this for each assigned team
Orange is Tickets Open and Blue is tix closed. Again it would be useful to see a breakdown by Teams/Owner
Orange is tix opened blue is tix closed
Thank you!
The dates have time, I created a new column without the time and joined with date dimension. Create some new column in date dimension.
https://www.dropbox.com/s/a4pnoz1fj721e6v/Incident_Mock.pbix?dl=0
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin