Seeing "(Blank)" twice in slicer and filter - desktop and service

[tlaresch2]

I am seeing (Blank) twice for one of my fields, whether I use it as a slicer or filter.  It picks 58 rows from my table visualization, but if I filter by null in the Query, I see only 54 rows.  Perhaps most interesting, in Desktop, if I click the second blank, it puts a check in the first blank value.  If I click it a second time, only the first value looks checked, but the top says "Workflow Status is (Blank) or (Blank)" (as shown below).  If I click it a third time, the second (Blank) gets a check mark.

[tlaresch2]

Idea created here: https://community.powerbi.com/t5/Issues/Bug-Seeing-quot-Blank-quot-twice-in-slicer-and-filter-deskto....

[v-kkf-msft · Accepted solution]

Hi @tlaresch2 ，

I see you found the cause in another post, so your problem has been solved? 

I believe the issue is because this one fact table has projectKeys that are not available in the dimension, and that is causing the Project dimension to somehow add a blank row to itself.  I did not think a fact table would affect a dimension table - I am working on a fix (adding the missing keys) and will post back on the results.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz

[amitchandak]

@tlaresch2 , This is strange.

Also, report an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues