Unable to show all x-axis single date values

[Anonymous]

Hi

Hoping someone might be able to help me!

I have a measure which calculates the number of people sick per day. I'm trying to plot this by each single day on a simple line graph. I'm using the date field from my date table in the x-axis and setting this to categorical, but the graph only ever shows the month end date and not each single day?

Does anyone know what the solution might be?

What's strange is if i store the number of sick days as a calculated column in the date table, it works fine. But this won't work as a solution as i need to filter the data by different variables

[Mkarwa-123]

@Anonymous  it seems you have 2 dates in sickness table and you are trying to compare 2 dates with single date in date table.  These 2 dates can't have active relationship with date table. 
which  date has active relationship between date and sickness ?

[Mkarwa-123]

@Anonymous  Add 0 to your sick days measure when there is no data for any date. It will help you to show all x-axis dates.

Did I answer your question? Mark my post as a solution!

[Anonymous]

@Mkarwa-123 thanks, this wasn't quite what i was after. However what it has done is highlight some sort of error in my calculation for sick days, where it's only calcualting the sickness for the last day of the month and not every single day.

Sick_per_day =

SUMX(filter(Date_table,Date_table[Is_Weekday]=1), COUNTROWS(filter(Sickness, Sickness[Absence Start Date]<=Date_table[Date] && (Sickness[Absence_end_date_NonBlank] >=Date_table[Date]))))

Any ideas?