Forum Discussion

mafioso's avatar
mafioso
Helper II
8 years ago

How to filter date for one table automatically by selecting it in other table

Hi,

 

I currently have this relationship, Budget and Actual Table: 

KSt_Idx is in both tables the primary key. Until now, I have always used two slicers:

So my question is: Is it possible to select the value in the Budget slicer and also to select it for the Actual slicer? Both tables contain a time period field (same structure). If I select for instance April in the Budget slicer, the Actual slicer also shows just the April value (due to the relationship). So now I want to remove the actual slicer and if I choose in the budget slicer April I want to apply it also for the other table without selecting it in a seperate slicer. Is that possible or not?

1 Reply