How to Remove Blank From Slicer in Power BI?

Do you know how to remove blank from Slicer in Power BI? OK, no Problem.

In this tutorial, I will explain the blank value in the Power BI slicer and how to remove a blank from the Power BI Slicer with a simple example.

Power BI Slicer Blank Value

In Power BI, a blank value in a slicer occurs when empty or null values are in the column used for the slicer. It appears as an option, allowing users to filter data where the specific column has no assigned value.

I also got the same issue with a Blank value when using the ‘EmployeeName’ field in the slicer. The screenshot below shows that a Blank field is automatically inserted into the slicer.

Power BI Remove Blank From Slicer

How to Remove Blank From Slicer in Power BI

Now, I will show how to remove a blank value from the Power BI slicer.

Below is a SharePoint list [Employee Leave List] I use for this Power BI Report tutorial. This list has these many columns below with different data types:

ColumnsData Types
EmployeeIDNumber
EmployeeNameSingle line of text
LeaveTypeSingle line of text
StartDateDate and time
EndDateDate and time
DurationNumber
StatusSingle line of text
How to Remove Blank From Slicer in Power BI

1. Open Power BI Desktop and load data using the Get data option.

how to remove the null blank from a Power BI slicer

2. Under the Visualizations panel, click Slicer Visual. Then, drag and drop EmployeeName into the slicer field.

Remove blank from Power bi slicer

3. Then, expand the ‘Filters’ panel (located on the right side of the Power BI Report page) and add the ‘EmployeeName’ (in my case, I am using ‘EmployeeName’ in the slicer) into the Filters on this page, as the screenshot below.

Remove Blank Option From Slicer in Power BI

4. In the Filter panel, Under the Filter type, select Advanced filtering -> under the Show items when the value select is not blank -> Click on the Apply filter.

Blank value in Power BI slicer

5. After applying the filter, the Blank value has been removed from the Power BI Slicer, as shown in the screenshot below.

How to Remove Blank Option From Slicer in Power BI

In this way, you can remove blank values from Power BI Slicer.

Conclusion

I hope this tutorial proves helpful. In this guide, we covered the Blank value in the Power BI slicer and how to remove it from the Power BI Slicer.

Also, you may like some more Power BI tutorials: