Direct Query Blank Values

[caldoy5]

I have imported data via Direct Query however one particular field displays some blank records (which is expected). These blank records are supposed to be used as a filter. However, the slicer does not recognize or pick up these Blank values. I have tried multiple IF statements, SWITCH statements, ISBLANK statements, power query editor, all in an effort to try a simply change these blank values to a value of 1 so that they appear and I can filter accordingly. Does anyone have any tips on how to solve this?

NOTE: I cannot provide data as it is sensitive.

[FreemanZ]

hi @caldoy5 

BLANK is not supposed to be replaced. You would need to look into your model, mostly to check if the one-side column fully covers the items in the many-side column. 

[caldoy5]

Hi @FreemanZ, thank you for your response. Could you explain this, I am not sure I understand what you mean?

[FreemanZ]

blank value is added automatically if the relationship is not solid. check more here:

https://www.sqlbi.com/articles/blank-row-in-dax/

[caldoy5]

That article is definitely useful so thank you for that! But these particular blank values are supposed to be blank and were put into the DB as blank values. Each customer has a code and if they have a blank code this resembles a ranking for them. I need to be able to add a slicer to my power Bi report enabling the end user to filter the customers based on their associated code, even if the code is blank, this should be a filter option. Anytime I add this filed to the slicer, the slicer will not recognize the blank values as a filter option. How can I combat this? My initial thought was to simply replace the blank value with a 1 from an IF statement but nothing changed. I also tried COALESCE  as well as ISBLANK