TOTALYTD PROJECTING DATA WITH NO EXISTING MONTHS

[Daniel_Rocha14]

Hello, i'm trying to create accumulate data, using TOTALYTD, but the function returns a projection based on the last month, when should returning nothing. The 31,85% its correct, but i dont have any data from the next month, june in this exemple

is there a way to display only the slice of months with data?

[olgad]

Create a filter for the page if(date>Today(), 0,1) 

Then place the filter onto a visual and pick 1 so you always look at the dates before today.

[Daniel_Rocha14]

I though on the same thing, and still show the projecting months. Only if i select the months manually works