no cumulative value in line chart when there are no actual values

[chriscools]

Hello,

how do i need to make a linechart with a cumulative total that stops drawing a line when there are no actua values instead of keeping a straight line?

i can't seem to work this out...

This is expression i have:

sum({<[Fiscal Year]={'2023 - 2024'}, [KPI's]={'KPI 1:Retail / Tafelen'} >}[factuur tot net])/1000

Thanx a lot!

grtz,

Chris

[Dataintellinalytics]

Please share sample data and snapshot.

[chriscools]

Hello,

attached a simple example.

There is a monthly budget amount for the total year, but the actuals only go untill month 8.

So i would like to find a way to stop showing the cumulative bar chart if there are no values anymore for actuals.

Is that possible?

grtz,

chris