I generally replace all the Cells with No Data in the Source with something like "-" or something. It is better than getting that annoying (Blank). I dont thinks there is a way to plainly not have that Blank Field on your slicer.
Just one Question, Why not delete the Rows that contain "Blank" in the source data? I dont think you will be using them if you prefer not to have Blanks in your Slicer anyways?
Cheers!
Deep![]()
Bookmarks