Pivot tabe shows "(blank)" even if "For empty cells show" is set to empty

%3CLINGO-SUB%20id%3D%22lingo-sub-3548035%22%20slang%3D%22en-US%22%3EPivot%20tabe%20shows%20%22(blank)%22%20even%20if%20%22For%20empty%20cells%20show%22%20is%20set%20to%20empty%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3548035%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20is%20this%20possible%3F%20Source%20cells%20are%20empty...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bartvana_0-1656079458588.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22bartvana_0-1656079458588.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22bartvana_0-1656079458588.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22bartvana_0-1656079458588.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22bartvana_0-1656079458588.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F383365i5D9637A18E8D7F29%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22bartvana_0-1656079458588.png%22%20alt%3D%22bartvana_0-1656079458588.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3548035%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3548508%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tabe%20shows%20%22(blank)%22%20even%20if%20%22For%20empty%20cells%20show%22%20is%20set%20to%20empty%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3548508%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863782%22%20target%3D%22_blank%22%3E%40bartvana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20setting%20works%20for%20values%2C%20not%20for%20rows%20labels.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20row%20labels%20as%20variant%20you%20may%20double%20click%20on%20any%20cell%20with%20(blank)%2C%20aka%20edit%20it%2C%20and%20enter%20any%20desired%20text%20or%20space.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3548549%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tabe%20shows%20%22(blank)%22%20even%20if%20%22For%20empty%20cells%20show%22%20is%20set%20to%20empty%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3548549%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863782%22%20target%3D%22_blank%22%3E%40bartvana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20setting%20just%20appies%20to%20fields%20in%20the%20value%20area%20of%20the%20pivot%20table.%20It%20has%20no%20effect%20on%20fields%20in%20the%20rows%20or%20columns%20area%2C%20which%20is%20the%20case%20in%20your%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20way%20to%20suppress%20%22(blank)%22%20in%20row%20or%20colum%20fields%20is%20to%20create%20conditional%20formatting%20rules.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

How is this possible? Source cells are empty...

bartvana_0-1656079458588.png

 

2 Replies

@bartvana 

This setting works for values, not for rows labels. 

In row labels as variant you may double click on any cell with (blank), aka edit it, and enter any desired text or space.

Hi @bartvana 

 

this setting just appies to fields in the value area of the pivot table. It has no effect on fields in the rows or columns area, which is the case in your example.

 

The only way to suppress "(blank)" in row or colum fields is to create conditional formatting rules.