When creating a line chart using a TOTALYTD measure—where the x-axis shows months and the legend shows years—it can sometimes result in the line for the most recent year rising until the last actual value, and then continuing flat for future dates.
It would be great to have a feature that allows the future portion of the line to be shown as a dashed line.
If there were a calendar table with a flag to distinguish current and future dates, it could be used to split the line visually. However, since those segments would be treated as separate series, the legend would show them as disconnected.
One workaround might be to duplicate the data for the transition month so both flags have values and the lines connect. But that could introduce a many-to-many relationship, which is best avoided.
So ideally, there would be a way to visually connect the current and future lines for the latest year, without creating a many-to-many relationship, and still allow solid lines for current dates and dashed lines for future dates.
