Forum Discussion

FrisoW's avatar
FrisoW
Icon for Helper I rankHelper 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.

FrisoW's avatar
FrisoW
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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