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

v-prasare's avatar
v-prasare
Community Support
6 months ago

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

 

 

 

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support