Issue with missing data in Timeline

[Anonymous]

Hello. I've run into an issue that I'm struggling to find an answer for. I'm building a timeline (line graph) using a table of summarized data (DAX SUMMARIZE). Here's an example:

The Service Count column is the value, Month is the axis, and Service Type is the legend. Service Count is an addition of Running Total and a lookup on service type from another table. Running Total is just that, a running total of the column Month Total. This gives a cumulative count from a specific starting point. All of this works as intented.  The problem is that this data comes from an activity table, and not every "service type" has activity every month. When this happens, the service count does not exist for that month and you end up with zig-zags or breaks in the line. In reality the change for that month was zero, which means the month total would be 0, running total and service count would be unchanged from the previous month. Ideally there would be an entry for the service type for that month with a month total of 0, however I have no way of adding that to the source data set. Any ideas out there? Thanks!

[Anonymous]

@Anonymous 

You should create the Running total and Service count and filter with your Calendar, and use the Calendar on x-axis. If you don't have one you can create a date table with Calender() or Calenderauto(), then related it with your Date column on your original table. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[Greg_Deckler]

Create a calendar table using CALENDARAUTO or CALENDAR. Relate it to your fact table. Use calendar table as x-axis.

Create a measure like:

...

RETURN

  IF(ISBLANK(<something>),0,<something>))