Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

2 blank values

I have a column in my report that is supposed to have 2 values, B and blank but when I added a slicer for sorting its showing me 3 options. Its showing (Blank), nothing and B. When I select (Blank) o...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

     

    The reason of a blank value in the slicer appears is because of a data integrity issue, in other words: you have some bad data in the data model.

    To fix the bad data, you need to go to the source. If that is not an option, you can fix it immediately and temporarily in Power BI.

    You can remove the (Blank) value in slicer and filter by following the Blank Value in the Power BI Slicer and Filter .

     

    Hope it helps,


    Community Support Team _ Caitlyn Yan

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

 

The reason of a blank value in the slicer appears is because of a data integrity issue, in other words: you have some bad data in the data model.

To fix the bad data, you need to go to the source. If that is not an option, you can fix it immediately and temporarily in Power BI.

You can remove the (Blank) value in slicer and filter by following the Blank Value in the Power BI Slicer and Filter .

 

Hope it helps,


Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.