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

 

 

 

Need Help

10 Replies

  • 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?