Forum Discussion

ms92ita's avatar
ms92ita
Helper I
3 years ago

line chart with dates and missing data

Hi,

 

I am getting some troubles on a report with direct query connection from a SQL server.
In this report i have a slicer of dates (between) and some charts/counters. Specifically I have a line chart that has no data in the highlighted part in the following screenshot:

 

The correct value would be 0 if not exists, but the line is continuous and this is not correct.
Creating a table with continuous dates and values is not an option because these graphs will be available for many customers from the same DB, so in a SQL server side the size would be big. Is there another mode or free graph that removes this error on a timeline?

Need Help
Tips and Tricks

7 Replies

  • negi007's avatar
    negi007
    Community Champion
    3 years ago

    ms92ita 

    It seems values are aggregating at month level. Please try to drill down one more level to date level

  • ms92ita's avatar
    ms92ita
    Helper I
    3 years ago

    As you can see, the granularity is per day and not aggregated... The visual is for a year.

    • negi007's avatar
      negi007
      Community Champion
      3 years ago

      ms92ita can you share your pbix file or sample data in table format which can be copied

      • ms92ita's avatar
        ms92ita
        Helper I
        3 years ago

        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: