Visual is showing an entire column as blank

[ewong18]

Hello, I'm having a strange situation with the Power BI.

I have dataset that is built in python, which is then exported into a spreadsheet. The Power BI then reads from the spreadsheet. For one particular column, if I create the column in python one way, it displays fine. However, I create it a different way, the visual in Power BI will show everything from that column as blank. The strange thing is that the column in the spread sheet, the preview in the Power BI query, and column in the Data section all show what is expected, and that there are values other than Blank. However, when I create the visualisation, it shows that the column has nothing but blanks. I've also verified with the corresponding filters.

Unfortunately the data is confidential so I will not be able to share screenshots. It's jut odd because I've created other columns in python with the same method and they don't have this issue. 

Does anyone have any ideas what would cause this?

[JarroVGIT]

Sounds like in one of the cases, the column is actually parsed as an invalid datatype. For example text instead of number?
Hard to think of anything else without any screenshots tbh:)
Let me know if this helps!

[ewong18]

That’s what I thought too!!! But the column is showing up as a text “ABC” column in both the PBI back end query as well as the front end Data section. The column is only used as a category in a bar chart. It’s being used as an axis. I wonder if the numpy NaN’s from the python could cause that issue? But I have other columns with NaN’s in the python that have been displaying perfectly fine.

[v-lid-msft]

Hi @ewong18 ,

Could you please try to create a calculated column using CalculatedColumn=TRIM([OriginColumn]) and then use the new column in a table visual ? What is the kind of Data Category of the origin column? 

Best regards,

[ewong18]

Hello,

Unfortunately, creating the new column with TRIM did not fix the issue.

Also, the Data Category is currently set to Uncategorized. The data wouldn't fall into any of the categories on the list.

Thank you

[JarroVGIT]

Would it be possible to share some screenshots of the PowerQuery screen in both cases? It is just guessing at this point without being able to see the data 🙂