Skip to main content

    Power BI

    Needs Votes

    Improve hierarchy slicer to hide blank members

    Vote (73) Share
    Pedro Roseira's profile image

    Pedro Roseira on 09 Oct 2020 14:03:35

    Hierarchy slicer does not hide blank members in ragged hierarchies when using live connection to SSAS Tabular and the property "hide members" in the hierarchy is set to "Hide Blank members".

    Excel hides the members correctly.

    It is also impossible to hide members when connected in import mode.

    This is a very requested feature and makes the usage of hierarchy slicers unusable in ragged/unballanced hierarchies.

    A common use case is a organizational hierarchy

    Comments (2)
    Pedro Roseira's profile image Profile Picture

    Kevin Goold on 28 Jun 2021 09:03:50

    RE: Improve hierarchy slicer to hide blank members

    Looks like a duplicate of https://ideas.powerbi.com/ideas/idea/?ideaid=224e24ba-b55c-4735-99ec-9dc2d3b55bf9

    Upvote that one!

    Pedro Roseira's profile image Profile Picture

    Pedro Roseira on 09 Oct 2020 14:08:47

    RE: Improve hierarchy slicer to hide blank members

    Here's an example: https://prnt.sc/uw7019