Line Chart not showing all data

[ITManuel]

Hi all,

I want to visualize the progress of projects via a line chart. I progress data such as below, basing on which the overall progress is calculated.

Unfortunately for some projects the line chart does not show all datas from the progress data, a few of the last months are missing. For some projects it does show the whole time period. 

The above example data is from a project of which the line chart goes only to december 2021 while the data goes until April 2022.

Here is the line chart:

This is my data model:

RP is data for Real progress (blue line, blue dotted for future forecast)

TP is data for Target progress (green line)

Date calendar table on this x-Axis.

Best regards

[amitchandak]

@ITManuel , Not very clear

If you want to show the missing month data too, You can add +0 to your measure

[ITManuel · Accepted solution]

Hi amitchandak ,

sorry, primitive fault. My calendar table was limiting the visulization not covering all dates in the fact table.

Thanks anyway.

Best regards

[Icey]

Hi @ITManuel ,

Glad to hear the issue is gone. Please accept your reply as the solution. Your contribution is highly appreciated.

Best Regards,

Icey