Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

(Blank)? Null? data in data pane

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 bett...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
aj1973
Community Champion
3 years ago

did you add the 0 tou your measures?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      aj1973
      Community Champion
      3 years ago

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

      Can you double check in Power Query please

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi,

         

        There are decimal numbers right now.