Slicer hide empty cells doesnt work

[mail2maciek]

Hello!

I would like to ask you for a help.

I have pivot table and pivot chart basing on excel table.
I have also created slicer with one dimension for which user can choose item to be presented.

The problem is:
The slicer list includes about 500 elements and only about 80 has any data.
I need to show on slice only those elements which has a data and not show empty elements.

The data in the source table is the result of the formula with if() and produce empty cell with "" on some conditions.
I noticed that the "" is replaced in pivot table to 0 and not to empty / blank cell and that couse slicer shows item even if it is theoretically empty.

I went through the numerous pages over the net, and found only one resolution to change formula to shows instead of "" - na() error and then
in pivot table's option change click box for error values show and box for empty cells show. That indeed changed 0 value in pivot table to empty
but still slicer presents this item in the box. That makes me think that slicer presents the item no matter if this is empty or na() or 0 if it finds anything in the cell.
As it finds formula then it present the item in the slicer.

I would like to ask you, for your help. How can I remove items which have 0 or na() or are empty in the base table.
As there is a vast majority of those the functionality of the slicer and pivot table is none. I can not remove the formulas.

thank you a lot.