Rows with null in a particular column are hidden.

[ZealandZu]

Hi All,

I have a table of task, along with a status column and date columns. One column has the days taken between two date column and if the task hasnt been started, then it shows null. Now this table was working fine and saved it. But after saving it, and loading up again this morning, now any tasks that havent started yet are not in the table. I have 'Show items with no data' ticked and as i said it was working fine and no its not. I have a DAX measure to count the amount of tasks not started and thats working fine, its just in the table. There are no slicers affecting it, nor any filters applied in power query either, as those tasks are showing up in query fine. Now this has happened before and I deleted the days difference column, and once it was removed from the table, the missing rows would return, however now even after doing this the rows are still hidden from view. Is this a bug or am i missing something? Thanks

[v-chenwuz-msft]

Hi @ZealandZu 

I created some data based on your description and tried it out, and the measure I used to figure out if it was started was written like this.

status =
IF(
    DATE( 2021, 10, 13 ) >= SELECTEDVALUE( 'Table'[SDate] ),
    "started",
    BLANK()
)

I don't know what your measure looks like, so can you share your desensitised data and measure?

I put my pbix file in the end you can reference.

Best Regards

Community Support Team _ chenwu zhu

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