Direct Query Blank Values

Question

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 · Answer

hi caldoy5&nbsp;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.&nbsp;

caldoy5 · Answer

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

freemanz · Answer

blank value is added automatically if the relationship is not solid. check more here:https://www.sqlbi.com/articles/blank-row-in-dax/&nbsp;

caldoy5 · Answer

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&nbsp; as well as ISBLANK&nbsp;

Forum Discussion

Direct Query Blank Values

4 Replies

Related content

merging direct query queries

RLS over Direct Query

Direct Query issue with Snowflake

MySQL Connector - Direct Query

History Data in Direct Query