Skip to main content

    Power BI

    New

    Slicer - hide items with no data

    Vote (92) Share
    Ivar Gjerde's profile image

    Ivar Gjerde on 10 Jul 2017 13:54:10

    Similar to in Excel, please enable a feature to hide values With no data in a slicer.

    E.g. I have a Dimension with a list of locations that change over time. I want my slicer to ONLY contain the locations that have data in 2017 (if I add a report level filter to filter for 2017). Currently, the slicer will list all the locations in the dimension.

    Comments (11)
    Ivar Gjerde's profile image Profile Picture

    a99e835e 0e27-4097-b28b-927e685edfab on 06 Jul 2020 00:11:07

    RE: Slicer - hide items with no data

    Really big issue

    Ivar Gjerde's profile image Profile Picture

    5826cfa8 0dea-46ee-9ea3-8c3c05dd9d8b on 06 Jul 2020 00:09:48

    RE: Slicer - hide items with no data

    I agree. I'm hunting for a solution to this. The slicers work well with each other ... they reduce and expand based on selection within slicers. However, when i click or select an item in the table, the slicer does not shrink relative to that item I've clicked in the table. That function is the rough = of the excel slicer function to hide items with no data in it. Its important as the slicer is a visual as well & so if i'm displaying sales data with region as a slicer and sales people and values as a table and I click on a particular sales person in the table, I would expect my slicer to also shrink to reflect the region data relevant to that person only instead of staying unchanged. For some reason, I remember that this used to work previously ... I could be wrong. Or is there a particular setting I'm missing to enable this.

    Ivar Gjerde's profile image Profile Picture

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

    RE: Slicer - hide items with no data

    This is essential!

    Ivar Gjerde's profile image Profile Picture

    c8408343 a6a0-40c4-b9f9-232c865e63a6 on 05 Jul 2020 23:41:14

    RE: Slicer - hide items with no data

    Only 65 votes? Seems like a huge improvement in usability to me.

    Ivar Gjerde's profile image Profile Picture

    a5b83494 a217-41aa-8b66-84fe9a57af0b on 05 Jul 2020 23:39:39

    RE: Slicer - hide items with no data

    Yes, must have functionality

    Ivar Gjerde's profile image Profile Picture

    e18f7d5f 734d-42ca-b84d-f7204ad9b8a3 on 05 Jul 2020 23:35:45

    RE: Slicer - hide items with no data

    I support the request

    Ivar Gjerde's profile image Profile Picture

    f81cbcec 2f6b-47a8-a6a7-7575d522557e on 05 Jul 2020 23:34:27

    RE: Slicer - hide items with no data

    I support the request. This functionality is very necessary!

    Ivar Gjerde's profile image Profile Picture

    195bbc06 9b71-4fdb-836c-6e1c9abd9b5a on 05 Jul 2020 23:27:38

    RE: Slicer - hide items with no data

    I support the request!

    Ivar Gjerde's profile image Profile Picture

    63ad2013 a0fe-4afe-be62-c53c68c80a74 on 05 Jul 2020 23:24:20

    RE: Slicer - hide items with no data

    I support the request. This functionality is very necessary for those of us who migrate our Excel reports to Power BI

    Ivar Gjerde's profile image Profile Picture

    58354d81 da27-428d-aae2-1208e69c67e0 on 05 Jul 2020 23:21:31

    RE: Slicer - hide items with no data

    I agree, this needs to be implemented like excel as users moving from Excel to Power BI reports, based on my own experiences are expecting only valid options based on filtered criteria.