Blank out Future Values in Chart

[ArchStanton1]

Hi,

Is there a way I can stop the black line at September so it only populates months that are current or in the past?

DD YTD Cases = CALCULATE(
    			TOTALYTD(COUNT('Cases'[Case Number]),'Date2'[Date],"31/3"))

Thanks,

[Ritaf1983 · Accepted solution]

Hi  @ArchStanton1 , there are several ways to filter out months without data for example :
Submitted_cases = calculate([DD YTD Cases], FILTER(ALL(Date),Date[Date]<=max(Date[Date])))

For a more detailed solution please share a dummy file to work with.

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

[ArchStanton]

Hi Rita, Apologies for the delayed acknowledgment, i thought I had already responded & approved this.
Your solution works perfectly!

[Ritaf1983]

Happy to help 🙂