Forum Discussion
Helper IIIBar chart - YoY comparison - Future Dates
Hello - I have a line/bar graph that tracks a number of people (Light blue line - previous year and dark blue line is the current year). The bars represent the YoY change. How do I write the formula for the YoY change so the future dates or blank or don't show up yet until the Current Year has data? So from 9/4/2022 through 12/2/22 it wouldn't show the bars since there is no current year data yet.
Current Measures:
WklyCY =
will it work if you put it as a filter in your calculate statments for current year and YOY?
4 Replies
- claymcooper
Resolver II
Create a calculated column based on your date column:
Future Date = IF(Date > Today(), "Y","N")
Then filter your visual based on that column so that Future Date = N
dwel0120claymcooper That doesn't work because I still need it to show the PY line (the light blue line in my original post).
- claymcooper
will it work if you put it as a filter in your calculate statments for current year and YOY?