Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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?
Hi @hansei ,
There is an idea about that, Please vote here:
I'm interested in understanding the behaviour. Why is this happening? How is it affected by other relationships in the model?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |