Forum Discussion
Helper Iline chart with dates and missing data
Helper IAs you can see, the granularity is per day and not aggregated... The visual is for a year.
Community Championms92ita can you share your pbix file or sample data in table format which can be copied
- ms92ita
PBIX is a bit complex to export beacuase the the chart a little part of a bigger report and I do not know how to export data from a calculated table. Anyway, the structure of the source data for time line is this:
X axis is date, while Items and TotalItems are line values
Another example is from FirstDate and LastDate as y-axis:- v-jingzhang
Community Support
Hi ms92ita
Please create the following measures for Items and TotalItems. They will return 0 for blank values. Use these measures for line values to replace the original columns.
M_Items = SUM ( 'TableName'[Items] ) + 0M_TotalItems = SUM ( 'TableName'[TotalItems] ) + 0Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.- ms92ita
Hi v-jingzhang
An additional measure is not the solution because the original table does not have a "continuous" value for dates, so in the summarization some dates would miss for sure.
Since that a table with continuous values for all customers will be massive and not optimized, can I link a "table" to a stored procedure that gets data from filters that I will send like customerid and min/max dates selected from a range? With that, from the database I can recreate a continuous time series.