Gaps in Line chart causing issues throughout chart

[dw0012]

I have about three dates missing from the data when I'm in the 1st slicer (slicers on the left). This is causing the bars not to populate when I'm in the 1st slicer and the select all slicer in this particular month. 

Month of February 1st slicer

Month of February Select ALL

Month of March Select all

I'm using the Service Date for my x, %absencemade up for column y axis, and attendancetypecount for line y axis.

%AbsenceMadeUp = DIVIDE([AttendanceTypeCountMU], 'AttMeasures_Counts'[AttendanceTypeCount], 0)

AttendanceTypeCount =

CALCULATE(

    COUNT(Attendance[Attendance Type Code]),

    FILTER(

        Attendance,

        (

            Attendance[Attendance Type Code] = "CA" ||

            Attendance[Attendance Type Code] = "CAL" ||

            Attendance[Attendance Type Code] = "CU" ||

            Attendance[Attendance Type Code] = "TA" ||

            Attendance[Attendance Type Code] = "TA-PTO"

        )

    )

)

[v-huijiey-msft · Accepted solution]

Hi @dw0012 ,

Thanks for the reply from @lbendlin .

Select the visual object and set the X-axis Type to Continuous. Try it?

My missing dates work fine in this mode.

If you can not solve it, can you provide me with the pbix link?

Please do not log in to your account in Power BI Desktop when uploading pbix files.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[dw0012]

I can't do continuous because I'm not including weekends, so the bars have huge gaps between them. 

[lbendlin]

ok.  What is your question?  What would be your expected result?