Forum Discussion
Phantom entry in visual
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?
4 Replies
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.
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?
I'm interested in understanding the behaviour. Why is this happening? How is it affected by other relationships in the model?
