Filter Is Blank not working / Is not Blank is Working

[luiz_aquino]

Hi All,

I'm trying to see the hours for projects I don't have a name (blank) as blank on the matrix, but I'm not able too see it.

See matrix below with no filter applied. Please see specifically the line for Augerud Glenn:

Now I'll will do the filter: Projects that are not blank:

And it worked fine, as the hours decreased. But if I do the opposite, to see just the hours when the project is blank, I'm not able to see them:

I have a link between the hours and project names, but I'm not able to see on the table lines "(blank)", when I don't have a project linked to that hours... I have slicer on other tabs, but not on this tab. How can I show projects that are blank? 

Thanks!!

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[luiz_aquino]

Complementing, seems like some blank data is appearing on the summary/total line, not under the line as a different line for project, called (blank)...

[Anonymous]

Hi @luiz_aquino ,

Please make sure you can find blank project when you add project column into your visuals. If this reply still couldn't help you solve your issue, please share a sample file with me and show me the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

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

[luiz_aquino]

@Anonymous , thanks for your reply!

Maybe this will help. See the matrix below. Some rows have the project below the general receiver and some don't. Why the ones that don't have it don't have a row below saying (blank)? Why are the rows with no associated project kind of collapsed and without a row below saying kind of "no project"or "blank"?

Thanks!

[luiz_aquino]

@Anonymous ,

If I use the same matrix, but just changing project to Cost Center, I can see the blank rows.

So, I think this is something related to the project field, or the link between hours and projects. I don't know if there's a way to set it, to not show blank rows and just collapse it...