Skip to main content

    Power BI

    New

    exclude filtered values from slicers

    Vote (14) Share
    EJM's profile image

    EJM on 08 Mar 2017 18:19:46

    If I filter out values on the page or report filters, related values should not be displayed in the slicers. e.g. a page filtered to cats, should not show breeds of dogs in the breeds slicer.

    Comments (2)
    EJM's profile image Profile Picture

    f92edb87 331f-4fdf-9e4a-6952445b8f9c on 05 Jul 2020 23:25:31

    RE: exclude filtered values from slicers

    FWIW, I believe this can be achieved now. You need to setup the relation of the tables which the slicers are using to be "BOTH". This would have the effect of when picking cats from one slicer, then only things related to cats appear in the other slicer(s).

    EJM's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:14:26

    RE: exclude filtered values from slicers

    And selected slicer value from filters. Make slicers and filters interactive.