Forum Discussion

FrisoW's avatar
FrisoW
Helper I
5 years ago
Solved

Empty colums

I have a similar issue (bug) I had before: https://community.powerbi.com/t5/Desktop/Empty-columns/m-p/999467#M474749   The problem is more or less the same: In "transform data" I have a column co...
Need Help
  • FrisoW's avatar
    FrisoW
    5 years ago

    I removed every column one by one so see when it went wrong.
    It was the "opportunityid" column, data source is Dynamics CRM. Once I removed that column, every calculation worked like it should. It makes no sense, but hopefully this can help someone with the same issue.

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi FrisoW ,

 

In that case, I would say after the SOURCE step in Query editor where you have Changed Datatype step, modify this column's datatype to TEXT. Then try unchecking the NULL values.

Because this looks like a datatype issue to me.

The best thing would be to replcae these NULL values with 0 in your column, then try filtering out these values.

NULL values can sometimes create a lot of issues.

 

Thanks,

Pragati

FrisoW's avatar
FrisoW
Helper I
5 years ago

Thanks for your input Pragati.

The problematic column is a conditional column with following config:

 

 

Previously the "else" value was "null". I changed it to "0".

This doesn't resolve the issue though, when I "remove empty" everything but "0" values are removed. Even when I create a filter "does not equal 123456789" all values except "0" disappear.

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi FrisoW ,

     

    So this looks like a text column.

    Can you replace 0 with NONE in your conditional rule?

    Try to keep the values in same data format and then check.

     

    If you still see issues, if it is possible share your pbix file by removing any sensitive information from it.

     

    Thanks,

    Pragati

    • FrisoW's avatar
      FrisoW
      Helper I
      5 years ago

      The output ("Estimated value") is a decimal number, or 0 if "TO status" is not "TO".

      So the conditional column is also a decimal number.

       

      Even when I replace the 0 with "none", and I select "remove empty", all rows containing numbers are deleted except the ones containing "none". This makes completely no sense to me.

       

      I'll try to remove confidential info of the pbix file later and upload it.

       

      Thanks again

      • FrisoW's avatar
        FrisoW
        Helper I
        5 years ago

        I found the problem but I cannot resolve it.

        When I remove all columns that are not needed for that specific conditional column, the step to "remove empty" works like it should and I can filter how I want.

        When I add those columns back (totally not related to those I use with the conditional column), the step fails.

        I don't know how to proceed.