Change or switch slicer selection based on another slicer?

Hi  AnaMariaDe ,To achieve dynamic slicer behavior in Power BI where the selection in one slicer (Area) influences another slicer (Project), you can use the following approaches:

Option 1: Sync Slicers with Filters and Relationships

1. Create a relationship:

   • Ensure the Area and Project fields are connected through proper relationships in your data model.
   • For example, if Area and Project are from different tables, create a relationship between them in the model view.

   • Apply cross-filtering:

     • Set the cross-filter direction to “Both” in the relationship settings if needed.

This ensures that selections in the Area slicer automatically filter the available options in the Project slicer.

Option 2: Use Measures and Conditional Filtering

If direct relationships don't work due to model complexity or other constraints:

Use a DAX measure to dynamically filter the Project slicer based on the Area slicer selection.

Example:

FilteredProjects = 
CALCULATE(
    DISTINCT('Project'[ProjectName]),
    FILTER('Table', 'Table'[Area] IN VALUES('Area'[Area]))
)

Add the measure to your visual or slicer:

Replace the default Project slicer field with this calculated measure.

Option 3: Use "Sync Slicers" and Bookmarks

If you need greater control:

1. Use bookmarks to save specific slicer selections.
2. Sync slicers across pages, ensuring the Area slicer determines the Project slicer’s scope.
3. Create a workflow: Use a combination of hidden visuals or buttons to mimic the behavior.

Please note:

If Area allows multiple selections, you might need to define rules for handling overlapping or cumulative Project selections.

Test the impact on performance if the model is large, as dynamic calculations can slow down visuals.

Please mark this as solution if it helps you. Appreciate Kudos.

Hi AnaMariaDe 

Unfortunately, as of now, Power BI does not support automatically clearing slicer selections based on changes in another slicer. To handle this scenario, you'll need to train users to manually click the "Clear Selection" (eraser) icon on the slicer to reset the filters.

However, there is an active feature request on this topic in the Power BI Ideas forum. I recommend voting for it to help prioritize its implementation:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ec054bc8-beaa-ec11-826e-501ac50a5d5c

I voted + shared with my colleagues.

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