Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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/
User | Count |
---|---|
139 | |
70 | |
67 | |
52 | |
52 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |