Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Graph the incident count over a time range by turning blank data to 0

Hello everyone I'm having trouble with the date filter (showing a date range) when it comes to graphing the count of the occurrences of some errors by months.   The problem lies in a pecualiarity ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    I updated your sample pbix file(see the attachment), please check if that is what you want. You can delete the relationship between the table 'Conocido' and 'Date Table'.

    Best Regards

  • Syndicate_Admin's avatar
    3 years ago

    Hello, I have already solved it. The creation of the table I had mentioned is enough. The Sum of incidents of the known table shows the desired result and manages to make the values disappear outside the date range that is determined through the filter.