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

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