Forum Discussion
Helper IHow to apply Year slicer value to a visualization filter
roytap,
You can create two year slicers to achieve the above reuqirement. Please follow the steps below.
1. Click on the first Year slicer, turn on Edit interactions. Then choose None for the second slicer and for the Matrix visual, choose Filter for the other three visuals.
2. Click on the second Year slicer, choose None for the first year slicer and for the other three visuals, choose filter for the Matrix visual.
This way, select value in the first year slicer to filter the three visuals and select multiple years in the second Year slicer to filter the Matrix visual.
Regards,
Lydia
roytap,
You can create two year slicers to achieve the above reuqirement. Please follow the steps below.
1. Click on the first Year slicer, turn on Edit interactions. Then choose None for the second slicer and for the Matrix visual, choose Filter for the other three visuals.
2. Click on the second Year slicer, choose None for the first year slicer and for the other three visuals, choose filter for the Matrix visual.
This way, select value in the first year slicer to filter the three visuals and select multiple years in the second Year slicer to filter the Matrix visual.
Regards,
Lydia
roytapThanks for the tips.
So i will need to create 2 year filters. This cannot be achieve with using only 1 year filter. This could confuse the user when there are 2 years filter on a single report.
roytap,
It is not possible to achieve your requirement by using a single year slicer.
Regards,
Lydia