Slicer - Hide (blank)

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,655
Office Version
  1. 365
Platform
  1. Windows
I have a slicer based on a Pivot table where a number of the rows in the table are empty for a specific field/column.

The resulting slicer for the column is showing as follows
1718686274202.png

I don't want the (blank) option to be visible and I understood that by using the Slicer Setting, I can hide the (blank) option
1718686347828.png


When I uncheck the Hide items with no data and then the two sub options, I expected the option to be removed from the slicer, but when I do this as follows and then click OK
1718686413265.png


The (blank) option is still visible in the slicer AND the Slicer settings show as follows when I go back into the Slicer settings
1718686467935.png


I now there is a way to do this as I have done this before but it seems something has changed and to do this, I need to do something else.

TIA
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top