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?