Extension of timeline with last data point.

[sebHan]

Hey!

I'm currently working on a timeline, where  I want the timeline to continue with the last data point.

Currently the timeline looks like this:

Basically I just want it to be a straigthline after October 2021 with 100.346 on every data point.

Is there a way to do this?

[Andrei_Cusnir · Accepted solution]

Hello,

You can use If statement in your expression for the Measure. For example I have the following Line Chart:

The Expression that I used is: Sum(Value)

Now if I use the following expression:

if(Sum(Value)=0, 100346, Sum(Value))

I get the output:

This tells the Chart Line to use the value 100346 where the sum of the value is 0 (which are the points after October 2021)

Is this the information that you were looking for? If it has helped you resolve the issue, please accept it as solution, to give more visibility to other community members. Otherwise, if I have misunderstood the use case scenario, please elaborate in detail, by providing additional information.