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
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.

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi AJ,

       

      Please see attached!

      Thanks for your help

       

       

      • aj1973's avatar
        aj1973
        Community Champion
        3 years ago

        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?