Time line visual

We have a time line visual of employees when they are on leave or sick, the table also shows all employees with the leave they get per year these are listed with StartDate = 01-01-2024 and EndDate 31-12-2024. Now I want to always show these employees despite what the choice is in the year and month slicer. Does anyone have an idea

Hi @WimH ,

Welcome back to Forum.

It seems like you need function that will change the filter context.
Maybe you can use:


Can you send a spreadsheet with the fictitious data, also containing an example?