Slicer item with no data (blank) is showing why

drom

Well-known Member
Joined
Mar 20, 2005
Messages
543
Office Version
  1. 2021
  2. 2019
  3. 2016
  4. 2013
  5. 2011
  6. 2010
  7. 2007
Hi and thanks in advance!

I have a TABLE, not a Pivot Table
This table is huge, so I have say 2 Slicers
The First Slicers named "QAZ" shows 3 options:
AA
BB
CC​
The 2nd Slicers named "Country" shows 5 options:
Spain
Italy
UK
Ireland
(blank)​

When the Table is Clear with non filtered data, there a re not blank items for the Column "QAZ", I mean the 1st Slicer named "QAZ" does not show blank items

If I select using the 2nd slicers the option(Blank) then the 1st slicers shows only the posibility "BB"

which is actually OK, because the option BB has some cells with no country

However when the Table is unfiltered if I use the first Slicers to select "CC" or "AA" then I have the possibility to select blank from within the 2nd slicer

but oviously if I select the (blank) option the Table shows nothing

What am I doing wrong and/or how can I avoid the Option (blank) if I know I do not have any

I mean why I am still having the Possibility to select (blank) as country when the Column "QAZ" for the option AA or CC does not have any blank country

ps:
I do not want to Use additional Columns and/or Slicers, VBA and/or
I am trying to know why this is happening
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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