Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data showing blank and null

Dears,

 

I've got a strange thing.

The data input is MySQL database. The Part Number column contains "Blank" and the ons look blank.  The "Blank" is really null, so IsBlank() returns "True". However, the cells look like blank, the IsBlank () result is "Flase", but len() returns 0. I'm so confued about this.

Could anyone help me with this?

 

Need Help

9 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    Onthe query editor try to find that specif record and make replacemente by null and see it works to make it blank.

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, MFelix 

       

      Thank you.
      These cells are not really null, so Replace Values doesn't work for them. And I even don't know what's in these cells.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Check for empty string

    count(countrrows(table),table[part_number] = "")

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks. My Recent Blog -
    Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
    Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

    Connect on Linkedin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, amitchandak 

      As you suggested, I create a new measure to count rows. Yes! The cells can be filtered by this measure: 

      Measure = countrows (FILTER('Query','Query'[Part Number]=""))

       

      But, why does the isblank() returns False and True, not True for all cells? I also want to know how does this situation occur, and then we can avoid this in the database.

       

      Thank you so much!


      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        HI Anonymous 

        First, for the problem why (Blank) and "" in the data filter in edit queries, that means there are blank(null) value in this column and the cell which has space character in the cell, and when you apply the query into power bi data view, they all will be balnk

        For example:
        Edit QUeriesPower bi data view

         

        Second, for why (Blank)  and "" will in a slicer together. So (Blank) will be in a slicer.

        You must have create a relationship with other tables, please see this post for details

        https://community.powerbi.com/t5/Desktop/Slicer-showing-Blank-as-a-value-when-data-does-not-have-any/td-p/301617

        and (Blank) in the slicer is to filter the data that in other tables which has no related data in 'Query' table, and "" is the data value in 'Query' table which is blank value.

         

        Regards,

        Lin