Try selecting the projection line, and changing labels to "most recent". I think that should do it! Make sure not to change this for the line of actual data.
Can you elaborate on that? If I change the "Label" options it would affect both lines and not just one line. Anyway to customize options by line?
One thing I failed to mention is that you need to use Dual Axis for this to work. If you're using Measure Names & Measure Values to display your multiple lines, you won't be able to use my suggestion. If you haven't used Dual Axes before, here's how you do it:
- Put both variables in the Rows pill
- Right click the 2nd variable, and click Dual Axis
- If your forecast line is in front, switch the order of the variables by just dragging the first variable to be after the second variable
- Right click the 2nd axis (on the right), and select Synchronize Axis and then unselect Show Header (this step is optional)
Now, on the marks card, select the options for the forecast line (make sure you're not under All), and change the label. Does this help?
Unfortunately I can't do that, I'm already using the other axis for another measure.
You could try making a calculated field, and then use that as your label. Depending how your data is structured, you could do something like this:
IF [data type] = "forecast" THEN [value]
This would only show forecast values, which is the same as the actual values when they overlap.