Remove blank from Power bi slicer

In this Power BI Tutorial, We will discuss a Power BI error as “Remove Blank from a Power BI Slicer“.

Table of Contents

Blank value in Power bi slicer

Many of the Power BI Developers may get this type of issue while they are using Power BI Slicer. When they are providing any field value into the Power BI Slicer, they can see some null values as “Blank” in the Slicer.

Similarly, I also got the same Blank value when I have used a Person field in the Slicer. In the below screenshot, you can see a Blank field is inserting automatically into the Slicer which should not be.

Remove blank from power bi slicer

To solve this issue from the Power BI Slicer, We need to follow the below processes:

First of all, Expand the Filters pane (from the Right side of the Power BI Report page) and add the Person field (for me, I am using a Person field in the Slicer) into the “Filters on this page” as shown below.

Just drag the Person field (FirstName) and drop it into the Filters on this page. Then do these below things:

Select “Advanced filtering” under the “Filter type” section.
Select “is not blank” under the “Show items when the value” section.
Click on the Apply filter button.

When you will apply the filter, then you can see the Blank value has been removed from the Power BI Slicer as in the below screenshot.

Also, you may like these Power BI Tutorials:

In this Power BI Tutorial, We discussed a Power BI error as “remove blank from power bi slicer”.

Bhawana Rathore

Hello Everyone!! I am Bhawana a SharePoint MVP and having about 10+ years of SharePoint experience as well as in .Net technologies. I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools. Now exploring more in SharePoint 2016 🙂 Hope here I can contribute and share my knowledge to the fullest. As I believe “There is no wealth like knowledge and no poverty like ignorance”