Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ExceLover
Frequent Visitor

SharePoint imported data containing blank cells not treated as blank

Hi,

 

I have a dataset that is a List in SharePoint, and it has has several columns. Some columns have several rows that do not contain data. This dataset was imported into Power BI from SharePoint. In Power BI, if there are any blank cells within this dataset, why does Power BI not regard these cells as actually blank?

 

I have attempted to create new columns that return a certain value if cells are greater than or equal to 0 and another if the cells are blank, but the results are incorrect because Power BI doesn't seem to treat empty cells as blanks.

 

When copying the table in Power BI and pasting into Excel and using a simple ISBLANK logic, the empty cells return FALSE.

 

Can anyone suggest what the best solution to this is?

 

Thanks

1 REPLY 1
vicky_
Super User
Super User

It might be the type of the column - for example, if the type is a string, then blank values are treated as an empty string (""), rather than a null value. So instead of checking for ISBLANK(), you would need to check for [Field] = "".
I think this article might help: https://www.sqlbi.com/articles/blank-handling-in-dax/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.