Forum Discussion
Blanks showing in table visual
swb128 Hi, happy to hear you found the issue! "Power Query analyzes the example file (by default, the first file in the list) and determines the correct file connector to use to open that file."
https://learn.microsoft.com/en-us/power-query/combine-files-overview
So It builds transformation steps (like types) based solely on that file. And those steps are then applied to all other files, even if they are different or leading to missing or null values like in your ListPrice column.
I would go back and inspect csv data in excel or notepad before I load them in power query, identify one of the incorrupt ones and use it as the first file.
Not sure if there's a better or automated way. Maybe other people can advise?
Solution SageHi swb128
Without seeing your actual report, it’s a bit tricky to pinpoint the exact cause, but here are the most likely explanations:
Data Type Mismatch Power BI might interpret the ListPrice column as text instead of a numeric format (or vice versa).
Aggregation Setting The table could be applying an aggregation (e.g., SUM/AVERAGE) that skips zeros.
Hidden Zero Values A visual-level filter or conditional formatting rule might be hiding zeros.
Measure Logic If ListPrice is a calculated measure (not a direct column), the DAX formula could be returning blanks.
Hi,
Thanks for the suggestions I will look into them now. Here is a better screenshot that shows some of the 'ListPrice' as blanks while other values in 'ListPrice' are being reported correctly, so everything in that column should be categorized the same with the same Data type.
swb128