Forum Discussion
Solved
Filter dependencies
Hello Everyone! I am trying to create a dashboard in which every visual throughout each page ideally depends on two slicers for which a value must be always selected. Period: WTD, MTD, QTD, YTD...
Hi vishbabariya
Can you try this approach
Two Date slicers and one Period slicer controlled by bookmarks
Create a Period table (WTD, MTD, QTD, YTD).Create a Date table with Date (dd/mm/yyyy) || Month Year (MMM yyyy). Add two Date slicers - Date || Month Year. Create two bookmarks, WTD - Date slicer visible. MTD/YTD - Month-Year slicer visible. Then Link bookmarks to Period slicer buttons (or use Selection pane).
vishbabariya You should be able to create your slicers on a page and then copy, sync and hide those slicers on every other page. This way, setting the slicers affects every single page in the report.