Auto-Reset Slicer Selection When Changing Selection in Main slycer

Hi margaridatedim ,

You can try formula like below:

FirstSalesType = 
CALCULATE(
    FIRSTNONBLANK('Sales Types'[Types], 1),
    FILTER(
        'Sales Types',
        'Sales Types'[Group] = SELECTEDVALUE('Sales Groups'[Group])
    )
)

SelectedSalesType = 
IF(
    ISFILTERED('Sales Types'[Types]),
    SELECTEDVALUE('Sales Types'[Types]),
    [FirstSalesType]
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi margaridatedim ,

Choose  SelectedSalesType to Filters on this visual. You can check pbix file i have provided.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.