Phantom entry in visual

[hansei]

I have a simple table visual that counts the number of entries for the 2 values of a column. You can see from the Data tab that the column only has 2 values- no (Blank), no empty string ("").

The visual on the left is as expected. However, a slicer for the column adds a (Blank) value where none exists. Similarly, in the visual on the right, when I add a measure that examines the column (seen in the formula bar), a Blank row is inserted even though the count remains blank too. There are no additional filters.

What is going on here?

[hansei]

The issue appears to be related to a relationship in the table. If the circled relationship is deleted, the issue goes away. If it is re-created, the issue reappears. It does not matter if the relationship is set to inactive- the issue is present if the relationship is defined. The filter direction (single/both) also makes no difference. Is there something about a second table that could cause this behaviour?

[v-frfei-msft]

Hi @hansei ,

There is an idea about that, Please vote here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9708828-bug-blank-appears-for-sli...

[hansei]

I'm interested in understanding the behaviour. Why is this happening? How is it affected by other relationships in the model?

[hansei]

Does anybody have any insight here? Once that phantom row gets created, every additional measure added to the table or visual creates some non-sensical entry in the phantom row.