Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    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

    Greg 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

    Power BI Ideas Admin on 05 Jul 2020 23:14:26

    RE: exclude filtered values from slicers

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