(Blank)? Null? data in data pane

[Anonymous]

Hi Power Bi, I am facing problem with a lot of (blank) in data pane.

Some of the filters are showing as (blank) and if I can get any help with removing all the (blank)s with 0 or whatever looks better.

The (blank)s look so ugly and my clients don't really want to see them.

When I go to the Power Query Editor and check the column in the table, there is no 0, empty or null data.

I tried some DAX and other ways I found in this forum but they all didn't work.

Can I please get some help?

[aj1973]

Hi @Anonymous 

The Blank() is coming from calculations made on columns, when there is no data it returns (Blank).

2 ways : Either you fil up the blank cells of the columns with 0 in Power Query or (which is better and cleaner) is to create measures for those cards and add 0 to it. Exemple : External =  CALCULATE(SUM('TableName(ColumnExternal)')) + 0

[Anonymous]

Hi Amine,

I tried both but still showing (blank).

I checked the column and they are all filled with '0' and there is no blank or null cells in the table.

Also tried DAX to remove the (blank)s, but not working....

[aj1973]

did you add the 0 tou your measures?

[Anonymous]

Hi,

I did, The table name is 'All Leased Labor Data' and the column name is [Leased Labor FTE], so I created measure as

CALCULATE(SUM('All Leased Labor Data'[Leased Labor FTE])) + 0

[aj1973]

Are you sure this column [Leased Labor FTE] is in Numeric format?

Can you double check in Power Query please

[Anonymous]

Hi,

There are decimal numbers right now.

[aj1973]

What do you mean? Can you show me the field in Power Query please?

[Anonymous]

Hi AJ,

Please see attached!

Thanks for your help

[aj1973]

this table is a reference from the original table right? therefore I don't think field is getting correctly the right Format.

Can you correct the format of the original table?

[Anonymous]

I did actually changed the format from text to number already....