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)
RE: Slicer - hide items with no data
This is really needed! Especially on live connections to SSAS, users should be guided to selections that make sense - i.e., elements that have no data associated should be hidden. Ideally, the same as one would do in MDX with a NONEMPTY([Set],[Measure]) command