Slicer - hide items with no data
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.
This is essential!
Jeroen Habets commented
Only 65 votes? Seems like a huge improvement in usability to me.
Pradeep Konda commented
Yes, must have functionality
I support the request
Denis Gerber commented
I support the request. This functionality is very necessary!
I support the request!
I support the request. This functionality is very necessary for those of us who migrate our Excel reports to Power BI
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.
Tommaso Pasini commented
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