Forum Discussion
Cumulative Graph Troubles
Hello
Trying to make a cumulative graph that shows data up till the last month, leaving the future months blank,
however ran into trouble of disappearing data The one 'grey' in July should be visible in August as well. The green is correct.
I have checked my filters and data to make sure there is no issue there, so it must be my formula calculation.
August is finally correct when I make a modification, however, I want the graphs to stop at August, not show anything for the future months. Please help!
Exits = COUNTROWS('In-Home')
Help appreciated!
16 Replies
Hi, not sure if you did had the solution but to remove the futur months use the suggestion from Ashish_Mathur but CONCATENATE the dates:
Measure =
VAR currentMonth =
CONCATENATE(YEAR(TODAY()), FORMAT(TODAY(), "MM"))
VAR monthNo =
FORMAT( MAX('T_BASS_DIM_DATE (Jobs)'[Date]),"YYYYMM" )
RETURN
IF ( monthNo <= currentMonth, [Cumulative To End of Year], BLANK() )Regards KeepCalm007
Anonymous
Hi KeepCalm007,
Could you try using the formula below to create a new measure which refers your [Comulative to Last Month] measure to see if it works? :smileyhappy:
New Measure = VAR currentMonth = MONTH ( today ) VAR monthNo = MONTH ( MAX ( 'In-Home'[Closed] ) ) RETURN IF ( monthNo < currentMonth, [Comulative to Last Month], BLANK () )Regards
Thank you for this suggestion, although it looked very promising,
I have tried it with both of the cumulative measures, but they do not give a different result:smileyfrustrated:
Hi KeepCalm007,
Could you share a sample pbix file which can reproduce the issue? So that we can further assist on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards
