PowerBI Slicer with Blank but unable to Filter correctly

[kitala11]

I used this DAX Query
DISTINCT(UNION(VALUES(TABLE1[COL]), VALUES(TABLE2[COL])))

to combine both the columns from different tables for their unique values (they are same columns just in different tables, but some has more categories than the others)

I get the follow categories for instance.

Blue Pen

Red Pen
Green Pen

(Blank)

When I use the DAX query as a slicer filter. I have no problem filtering both tables to get their correct values.

However, when I check the (Blank), no values appear, even though one of the tables have values for (Blank). 

What is the problem here?
Are slicers unable to filter for (Blanks) and retrieve their values? - My impression is that this is possible, since when I put it in a table format, beside the blank there are values. 

TLDR : Slicer using DAX, has a (Blank) selection. But (Blank) selection does not yield any value even though there are supposed to be

Let me know if it is not clear enough

[v-robertq-msft]

Hi, @kitala11 

According to your description, you said that when you put it in a table format, besides the blank there are values, but in the Slicer, the (Blank) selection does not yield any value even though there are supposed to be. I think the problem can exist in the field you placed into the charts, the DAX formula you used, and the relationship between your data tables.

If you just want to make the blank selection disappear in your Slicer, you can just change the DAX Query like this:

Table=

FILTER(DISTINCT(UNION(VALUES(TABLE1[COL]), VALUES(TABLE2[COL]))),[COL]<>BLANK())

If you still have a problem with this issue, would you like to post some sample data in table form or pbix file(without sensitive data) and your expected result(like the chart you want to get and the correct measure value based on your sample data)?

Thanks very much!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@kitala11 , first you need to understand

https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/

https://www.youtube.com/watch?v=23qemkDqMVY

[kitala11]

Hi, I think you misunderstood what I am saying. 

1) I know why there is a (Blank) Value in my slicer, because THERE IS a (Blank) Value for that column of my table)
What I want to know is

2) Why does the (Blank) filter in the slicer not produce any data, but when it is in a table, it clearly does show data that correctly correspond to it (this is what im looking for)

[amitchandak]

@kitala11 , Ideally I would not like to have a blank value. If it is there. I would like to address that in the power query and assign some value.