Perfectly Linear Line Changing

[willchamp]

I have a table that contains dates and a fixed value. For example:

Date	Value
4/17/2025	20
4/18/2025	20
4/19/2025	20

I have a running total calc that takes the value and adds it to the previous cumulative value, based on the date:

Cumulative Target = 
CALCULATE(
    SUM('Targets Table'[Value]),
    'Targets Table'[Date] <= max('Targets Table'[Date]),
    ALLSELECTED('Main Table'[Program Manager])
)

This correctly provides me with a sloped line showing the cumulative value, over the date, as shown below:

When I change the program manager filter, though, it loses the perfect slope, and if the program manager doesn't have an actual value for that day, it jumps:

How can I keep it so that the green (target) line loses those jumps?

[V-yubandi-msft]

Hi @willchamp ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[V-yubandi-msft]

Hi @willchamp ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @willchamp ,

@lbendlin , provided a good response. Please try his solution and see if it works for your scenario. If everything is running smoothly now.  However, if you need any further clarification or additional details, please let us know.

If your issue has been resolved, please mark it as accepted solution . This helps other community members find the solution quickly.

Regards,

Yugandhar.

[lbendlin · Accepted solution]

To report on things that are not there you need to use disconnected tables and/or crossjoins

Your x axis must come from the Calendar dimension. Either enable "show items with no data"  or leave the table disconnected and use measures.