Problem with line chart

[peteralberts]

I have 2 reports with a "two line" line chart visual.

1. PowerBI report, with excel import data for a forcast 12 month values, and an actual YTD values up to the current month

2. Exact same report logic, but the 2nd PowerBI report MS SQL direct query for a forcast 12 month values, and an actual YTD values up to the current month

Problem;

Both reports show the forcasted 12 month values the same and correctly. The excel DB report for the actuals shows up to the YTD current month correctly, and then the line stops at the current month

My problem is that for the actuals in the direct query report, then actuals YTD shows correctly, but then the line carries on at a flatline through to the end of the 12 month period.

I have looked at all logic, whatever I could check and stumped with this issue.

The users would like the direct query report actual line also to stop at the current month

Are there possible difference in how imported vs direct query values are presented to the visuals that could cause this, or a setting that I am missing on the visual

Any insights and help to understand appreciated

[peteralberts]

Thank you, this solution works perfectly

[v-kkf-msft · Accepted solution]

Hi @peteralberts ,

I couldn't reproduct your problem, the following image is the line chart I created with import and direct query mode, both of which are consistent. 

I think you need use a measure, like this:

Measure = 
IF(
    SUM('Table'[Resolved Cumulative]) = 0,
    BLANK(), 
    SUM('Table'[Resolved Cumulative])
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

To prevent rendering of future data points change your measure to output BLANK() in such a scenario.