Skip to main content

    Power BI

    Needs Votes

    Gray-out empty slicer items

    Vote (17) Share
    Assaf's profile image

    Assaf on 29 Nov 2016 23:49:20

    When data is filtered, slicer items that represent no data should be grayed out (or otherwise indicate this) - similar to the behavior of slicers in Excel.

    This would help the user to see which slicer categories actually contribute data to the report.

    Comments (2)
    Assaf's profile image Profile Picture

    K V on 05 Jul 2020 23:29:35

    RE: Gray-out empty slicer items

    Agree. Having inapplicable slicers just disappear is confusing.

    Assaf's profile image Profile Picture

    rgoerwit on 05 Jul 2020 22:40:41

    RE: Gray-out empty slicer items

    Agreed. Again this is an area where Excel exceeds Power BI in what it offers.

    I often need to explain why we should use Power BI and not Excel. Feature parity in areas like this would help me make the case for Power BI. My users aren't going to be happy with slicers in Power BI that reduce their ability to analyze data effectively.