how to hide the blank selection in slicer

[erihsehc]

Hello, I would like to know how to hide the blank in slicer. the first screenshot is the original slicers with blank selection. after filtered "is not blank" for FY outlook, the YTD actual slicer changed (total selection reduced from 6 to 4). How to just hide the blank in slicer instead of filter out blank (do not want to affect another slicer due to fliter out blank). thanks

Best regards

ER

[v-caliao-msft]

@erihsehc,

Currently, to remove a blank selection in a slicer, we can use this technique. Drag your field onto the canvas and Select the Visual in which you can filter the blank value using page level filters and then change that visual to the slicer. That's it.

So if we add a page level filter, it will have impact for others visual. I am afraid there is no such an option to aviod this issue. 

Thank you for your understanding.

Regards,

Charlie Liao

[erihsehc]

---

@v-caliao-msft wrote:

@erihsehc,

Currently, to remove a blank selection in a slicer, we can use this technique. Drag your field onto the canvas and Select the Visual in which you can filter the blank value using page level filters and then change that visual to the slicer. That's it.

So if we add a page level filter, it will have impact for others visual. I am afraid there is no such an option to aviod this issue. 

Thank you for your understanding.

Regards,

Charlie Liao

---

hi @v-caliao-msft, I am not getting the below technique. pbix, attached the pbix, would you help to show that in the file? thanks a lot

we can use this technique. Drag your field onto the canvas and Select the Visual in which you can filter the blank value using page level filters and then change that visual to the slicer

[v-caliao-msft]

@erihsehc,

I add custom and division to page filter and unselect blank value. 

Regards,

Charlie liao

[erihsehc]

hi @v-caliao-msft, got your idea but customer B disappear from slicer. It that possible to show all selection except blank?