Forum Discussion
Direct Query Blank Values
Hi FreemanZ, thank you for your response. Could you explain this, I am not sure I understand what you mean?
blank value is added automatically if the relationship is not solid. check more here:
https://www.sqlbi.com/articles/blank-row-in-dax/
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