How to show all the dates, including those with no data?

[BenBlackswan]

Hello I have a table that has three columns like this, as you can see the latest data I have is up to 20th Feb 2025.

When I do a line chart, the chart only goes up to 20 Feb 2025 as below

I would like to chart a line chart that shows for the entire 2025 year, like this chart done in Excel.

What is the best way I can do that?

[BenBlackswan · Accepted solution]

omg it was as simple as setting a fixed range in the x-axis....

[danextian]

Hi @BenBlackswan 

You can change your X-axis to categorical but that will restul to disconnected lines.

Or write a measure that adds zero to the original value and use categorical.

Sum + 0 = 
SUM('Table'[Value]) + 0

Or write a measure that returns zero for the latest date if it doesn't have a value and use a continuous x-axis

New Value =
VAR _LatestDate =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) )
VAR _Value =
    SUM ( 'Table'[Value] )
RETURN
    IF ( _LatestDate = SELECTEDVALUE ( 'Table'[Date] ), 0 + _Value, _Value )

[danextian]

Hi @BenBlackswan 

Have you tried this toggling this on?

[BenBlackswan]

hi @danextian 

Thank you for the reply.

It is still not working after I checked that option