Forum Discussion

vishbabariya's avatar
vishbabariya
Regular Visitor
6 months ago
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...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    6 months ago

    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).

krishnakanth240's avatar
krishnakanth240
Super User
6 months ago

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).