Forum Discussion
Removing a possible user selection from a slicer
Hello Dan_TWE,
The slicer option “Hide items with no data” only hides values that are truly unused in the current filtered dataset. A blank cell in your source is still treated as a valid value, so Excel shows (blank) in the slicer even when that option is checked. To remove (blank) from the slicer without removing those rows from your data, you need to use a helper column (for example =IF(ISBLANK([@Field]),"Hidden",[@Field])) and use that helper field in your slicer instead, then filter out “Hidden”.
This behavior is consistent with how slicers work in Excel; slicers show all distinct values from the source field and only hide values that are not present in the filtered data context, not blanks by default.
See Microsoft documentation on using slicers to filter data:Use slicers to filter data
Hello Dan_TWE,
The slicer option “Hide items with no data” only hides values that are truly unused in the current filtered dataset. A blank cell in your source is still treated as a valid value, so Excel shows (blank) in the slicer even when that option is checked. To remove (blank) from the slicer without removing those rows from your data, you need to use a helper column (for example =IF(ISBLANK([@Field]),"Hidden",[@Field])) and use that helper field in your slicer instead, then filter out “Hidden”.
This behavior is consistent with how slicers work in Excel; slicers show all distinct values from the source field and only hide values that are not present in the filtered data context, not blanks by default.
See Microsoft documentation on using slicers to filter data:Use slicers to filter data
Thanks. That info will help.
