Blank Calendar date in line chart

[vmaru]

Hi,
I have a case table that has openeddate and closeddate columns. I want to show the count of ticket opened date and ticket closed date as values in a line chart and calendar date field in the axis. For Calendar date, I used the formula CALENDAR(Min([openeddate].[Date]), MAX([openeddate].[Date])) and mapped the date column with the openedate column. I am trying to use this calendar date in a line graph and it is blank. Not sure where I am going wrong in this. Hoping someone can help me resolve the issue.

Case Table:
number openeddate closeddate
C1001 10/17/2019 4:47:22 AM 10/17/2019 9:47:22 AM
C1002 10/17/2019 6:40:00 AM 10/18/2019 1:00:22 PM
C1003 10/19/2021 8:25:00 PM 10/21/2021 2:7:32 PM
C1004 11/17/2021 6:25:00 PM 11/26/2021 8:15:45 AM
C1005 11/25/2021 6:00:00 PM 11/26/2021 3:47:22 PM

Calendar Table:
Date Month Name Month Number Quarter Year
1/1/2019 January 1 1 2019

Expected Result:

Date Count of openeeddate Count of closeddate
10/17/2019 2 1
10/18/2019 1
.
.
11/25/2021 1

The expected result is to plot the table in a line chart.

Thanks!

[v-shex-msft · Accepted solution]

HI @vmaru,

It sounds like a common date range analysis requirement, you can take a look at the following link 'start date', 'end date' parts it helps:

Before You Post, Read This 

In addition, you can also try to create a bridge table to expand the date range from the original table. Then use its field link to raw table and use expand table date field as axis, raw table records as value for data analysis:

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[MFelix]

Hi @vmaru ,

Try to add a column with only the opendate on your model and make the connection between the calendar and the fact table. DateTime and Date columns are not the best way to have date relationship.