Forum Discussion

AnaMariaDe's avatar
AnaMariaDe
Regular Visitor
1 year ago

Change or switch slicer selection based on another slicer?

Hi all,    I would like to ask for your help or some suggestions to manage a situation. Let me explain better: I have two filters, area and project. The area is a dropdown filter with multiple sel...
Need Help
Tips and Tricks
Tutorial Requests
Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi , Please Try these 

  • Ensure a relationship exists between the Area and Project tables.
  • Create a measure to filter projects dynamically
    FilterProjects = IF(SELECTEDVALUE(Area[Area]) = MAX(Project[Area]), 1, 0)

  • Apply this measure to the Project slicer as a filter (FilterProjects = 1).

  • Use Sync Slicers to link the Area and Project slicers, ensuring previous selections are cleared.
    If this post helped please do give a kudos and accept this as solution
    Thanks In Advance