Forum Discussion

dw0012's avatar
dw0012
New Member
2 years ago
Solved

Gaps in Line chart causing issues throughout chart

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"
        )
    )
)
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      dw0012
      New Member
      2 years ago

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