BLANK value not disappearing in Y axis

[Anonymous]

Hi everyone
I've been having this problem today

As you can see in my screenshot there is a measure (it's a simple countrows of the fact table PLUS ZERO to make an eventual "blank" value show as 0 in the visual in case the user makes a selection in the slicers that makes the value become BLANK) and also the (Blank) value is shown in the axis. There are no rows with a BLANK value for the column I'm using to slice. It's populated in the DB and it cannot be BLANK. However, since I put a +0 in the measure it's showing me also the BLANK value in the axis

I don't understand however why I'm not able to filter this out of the visual since I don't want to show it in the axis. 
I seem to remember that I could do that in the past. 
Removing the "+0" from my measure is something I'd rather not do because I want the axis to show (with a 0 as data label) even if a certain value of those 3 is not present in a certain filter context. If I remove it, the axis will simply disappear 

Why am I unable to filter out just the BLANK value in the axis? Has it always worked this way?

[Anonymous]

@Anonymous 

With my test +0 will show a blank field, without+0 at the end, the blank just disappear.

I could not reproduce that issue with blanks appears on my the y axis, can you post a sample pbix with that issue.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[MFelix]

Hi @Anonymous ,

Does the column that you use for lead_status comes from the same fact table where you are calculating the measure or is it from a dimension table?

Usually when I have this type of things is related with the fact that some of the columns in the dimension table don't have values on the fact table.

If you don't have blanks on the column you use this value should not appear, can you share the measure code?