Forum Discussion
How to Change Starting Point for Line Chart
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 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!!!
2 Replies
- v-lili6-msftCommunity Support
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- ShelleyPost Prodigy
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!!!