Skip to main content

    Power BI

    Needs Votes

    Slicer Select All vs Select None

    Vote (61) Share
    's profile image

    on 03 Mar 2017 05:54:16

    Would be nice if when select all is enabled on a slicer that when you choose select all it shows everything in associated visualizations BUT when you de-select all the associated visualizations show nothing. At present either option shows everything.

    Comments (11)
    's profile image Profile Picture

    David Marchant on 05 Jul 2020 22:42:12

    RE: Slicer Select All vs Select None

    Note that without Select All showing I can achieve the desired result using a measure like this as a filter on the associated visualizations:

    MySlicer = IF (
    ISFILTERED('MyTable'[MyColumn]),
    "Y",
    "N"
    )

    where 'MyTable'[MyColumn] is what is used for the values in the slicer.