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.
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:
| Columns | Data Types |
|---|---|
| EmployeeID | Number |
| EmployeeName | Single line of text |
| LeaveType | Single line of text |
| StartDate | Date and time |
| EndDate | Date and time |
| Duration | Number |
| Status | Single line of text |
1. Open Power BI Desktop and load data using the Get data option.
2. Under the Visualizations panel, click Slicer Visual. Then, drag and drop EmployeeName into the slicer field.
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.
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.
5. After applying the filter, the Blank value has been removed from the Power BI Slicer, as shown in the screenshot below.
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:
- Select Multiple Values in Power BI Slicer
- Sort Slicer in Power BI
- Sync Slicers in Power BI
- Add Multiple Columns in Power BI Matrix
Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.
