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,

 

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.

    • 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