Forum Discussion

ddevadas's avatar
ddevadas
Regular Visitor
3 years ago

Graph for daily checklist

Hello,

I am preparing a checklist that is expected perform daily and I am creating a dashboard to review the days missed out from being performed.

Checklist is a form using MS Forms and upon submitting, I utilise the completion time. I compare with another table created using calendar command with start date as year beginning and end date as NOW().

While building a matrix with all dates alloted, I am not able to fetch the days that forms are not submitted.


Appreciate if anyone can guide me to place the blank value on the corresponding date so that I am able to figure out missed out days.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    ddevadas , Use a date table joined with date of your table. Use date table in visual and slicer

     

    Then have a measure with +0

     

    or use this option

    • ddevadas's avatar
      ddevadas
      Regular Visitor
      3 years ago

      Thanks for the response.

      I did that but when I add 0 - it is taking the numeric date i.e., 31/12/1899..and upon checking the visual i have the following error - "Too man values - Too many 'Year, Month, Day' values. Not displaying all data. Filter the data or choose another field.