How to Change Starting Point for Line Chart

[Shelley]

Hi All, I'm working on an expression that by default will show a YTD cumulation, but if/when a user selects years, then it will accumulate for all the years combined. I think I've got the formula working as intended; however, for the current YTD, the line chart begins at the start of the dataset and I want it to start at the beginning of this fiscal year, 10/1/19.

Here's my formula.

YTD or Cumulative Total Wins =

IF(ISFILTERED('RA_Daily_Calendar'[Fiscal_Year]),
CALCULATE([Total Wins],
FILTER(CALCULATETABLE(SUMMARIZE('RA_Daily_Calendar', 'RA_Daily_Calendar'[Fiscal_YearMonth]),
ALLSELECTED('RA_Daily_Calendar')),
ISONORAFTER('RA_Daily_Calendar'[Fiscal_YearMonth], MAX('RA_Daily_Calendar'[Fiscal_YearMonth]), DESC)
)),
(CALCULATE ([Total Wins],
FILTER (ALLSELECTED ( 'RA_Daily_Calendar' ),
AND ('RA_Daily_Calendar'[Date] <= MAX(RA_Daily_Calendar[Date]), RA_Daily_Calendar[Flag: Current Fiscal Year] = 1)
))))

When fiscal year is filtered, it displays as I desire:

However, for the default view of current year to date, it draws like this:

Whereas, I desire this:@Anonymous or Mike_Carlo Any ideas? Thanks in advance!

[v-lili6-msft]

hi, @Shelley 

I think if there is a conditional "+0" in the measure [Total Wins]

If so, just remove "+0" in measure [Total Wins].

If not your case, please share a simple sample pbix file.

Best Regards,
Lin

[Shelley · Accepted solution]

@v-lili6-msft Lin! You are so right! I had this so it wouldn't show Blank() in another area of the report. I forgot about it. Thank you so much!!!