Using Dates in Visuals

[cdizzle22]

Good Afternoon,

I am currently trying to build a dashboard that measures a count of tickets opened and closed by Year, Month, and Day in a stacked bar chart or line chart. 

The counts of opened and closed tickets is coming out correctly but when I try to use Date as the x axis I cannot get the date to respect each value. 

If the date of opened is used, the number of opened reports correctly but the number of closed is not accurate. If the date of closed is used, the number of closed reports correctly but the number of opened is not accurate.

When creating a new table for date and creating a relationship this does not come out clean either.

How can I use a default date heiarchy that reports both closed and opened for a given, Year, Month, or Day correctly.

Thanks!

[cdizzle22]

This worked like a charm, Thanks!

[amitchandak · Accepted solution]

@cdizzle22 , This seem like same case as this one

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.