How to show trend line for date in the future

[kiko]

I want to plot a line graph with an actual count and goal. The actual is calculated using RunningSum and goal is calculated using Ifelse:

Goal

However, even if I select the date to be until the end of 2025, only up to date month is shown on the line graph

Is there anyway to show the date to end of this year so I can display all goal numbers in the line graph?

Thank you!

[Xclipse]

Hi @kiko

QuickSight will only plot a point for months that actually exist in your data, so “extending” the axis to Dec-2025 means you first need to give it rows for those future months. You have to import rows for those future months.