Forum Discussion
ANJ
2 years agoFrequent Visitor
Syncing 2 slicers from same table
I've searched and didn't see anything specifically related to this. Maybe it's not possible. I have a calendar/dimension table: Date FYear FWeek FPeriod 01/09/2023 2024 1 1 02/09...
- 2 years ago
hello ANJ
i think you can just enable those slicer interaction.
you see, by default when creating multiple slicer, their interaction was disable.
so here is the example,
when i set in index slicer 7 to 8, the value in API is 111 to 149.
when i enable their interaction, index slicer still 7 to 8, but API slicer show 111 to 121.
the maximum value in slicer is changed from 149 to 121.
and you need to re-enable their interaction each other. First slicer to second slicer and vice versa or else the value wont change to slicer with disable interaction.
Hope this will help.
Thank you.
Kaviraj11
2 years agoSolution Sage
Hi,
You can create a measure and put the measure in filter pane and set it to 1. It will only display the values that are available.
SlicerFilter = INT ( NOT ISEMPTY ( 'Your dataset' ) )