I'm trying to apply two independent year filters to a custom chart: one for actual values and another for forecast values. The goal is for each filter to work independently and allow multiple selections. For example, the user should be able to select 2016 and 2018 for actual values, and at the same time select 2020 and 2022 for forecast values — displaying four distinct lines on the same chart: two for actuals and two for forecasts. Currently, the chart behavior is incorrect: when applying a year filter (e.g., 2016), it always returns two lines — one for actual and one for forecast — for the same year. This prevents users from independently combining different years for each type of value. The objective is to make the filters independent so that it's possible to freely combine multiple years of actual values and multiple years of forecast values in the same chart, without one filter affecting the other. @HunterT_SAS Currently, I managed to implement independent year filters by pivoting the data table, placing both forecast and actual values into the same column, and using an additional field to distinguish between the two. This solution allows me to filter years independently for forecast and actual data, and it's fully functional using standard chart components. However, by using this approach, I lose the ability to use my custom chart configuration, where dashed lines visually represent forecast values and solid lines represent actual values. That visual distinction was previously handled in the custom chart logic, which relied on the values being in separate series or fields. In other words, while the pivoted solution allows for functional filtering, it comes at the cost of losing the visual styling and behavior that was possible with the original custom chart setup. What I need is a way to combine both functionalities: Keep forecast and actual values in separate series (to enable visual customization, like dashed lines for forecasts), But still allow for independent year filtering for each series.
... View more
