Hi @Geral
Welcome to the QuickSight community!
The issue you’re facing, where adding a year filter deletes the calculated YoY (Year-over-Year) field, occurs because of how filtering affects the data context for calculated fields. When you apply a year filter (e.g., selecting only ‘2024’), QuickSight only retains data for the filtered year. In this case, it removes the ‘2023’ data from the context, meaning that your calculated field no longer has access to both years (‘2023’ and ‘2024’). As a result, the calculation for YoY growth fails since it cannot retrieve values for both years simultaneously.
Your YoY calculation is dependent on data from both 2023 and 2024. When a year filter restricts the data to only a single year (e.g., 2024), the previous year’s value (e.g., 2023) is not available, causing the calculated field to break.
Consider using parameters instead of direct year filtering. Create two parameters for the start year and end year. This way, you have more control over which years are used for the calculation without entirely excluding them from the dataset.
Please refer to the below QuickSight documentation and community post this might be helpful for you.