(Blank) gets added in Slicer

Hello

I have created slicer - FY, to filter the visuals in Power BI.
I have perfect date table setup. I don’t know why I am getting (Blank) in the slicer. How to get rid of the (Blanks) in slicer.

image

I have added the Power BI model along with this.

ProdPerformance.pbix (1.5 MB)

Hi Krishna,

I have had the same issue in the past. What I would do is to drag your FY column to the page level filters. Then, you should select all and while pressing control in your keyboard, uncheck the blank option.

I hope this can help :wink:

Lucia

2 Likes

Yes Lucia - Your idea is working.

Many Thanks.

1 Like

Is a pleasure for me being able to help others !

Cheers!

Lucia

1 Like

That’s great. Thanks yes this is how I would fix it quickly also.

1 Like

Another option is to go into advanced filtering and select “is not blank”. Is Not Blank

To the contributor of this post. Thank you for sharing your experiences around Power BI, please don’t hesitate to add more discussion or add value to wherever you think you possess the experience or knowledge that can help others in our Ecosystem Group. You can also help us in improving the Support forum further by answering the Enterprise DNA Forum User Experience Survey. We appreciate the initiative and your help in this group!