Blanks showing in table visual

[swb128]

Hi,

I have a table visual that is showing some blanks for 1 of my columns 'ListPrice'. However, when looking at the excel file, there is data in each row in the 'ListPrice' column. Why is this happening?

swb128

[MasonMA · Accepted solution]

@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.

[v-pgoloju]

Hi @swb128,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @swb128,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @MasonMA , @danextian , @Elena_Kalina  and @Abhilash_P  for their prompt and helpful response

Just following up to see if the solutions or suggestions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @swb128,

Just following up to see if the issue with the 'ListPrice' column showing blanks in your table visual despite the Excel file having data was resolved. Let me know if you need help identifying why this one column might not be loading correctly or if you need assistance reloading the data properly.

Best regards,
Prasanna Kumar

[swb128]

Hi Mason,

I tried your suggestion using the IsBlank function and found the issue! Thanks! I have 5 csv files that are being used and I did 'Combine & Load' and made the 5 CSV files into 1 table. However, looking at the Table View, one of the CSV files seems to have blanks for the 'ListPrice' column. However, when I look at the original CSV file, there is data in the 'ListPrice' column. Somehow, the data got wiped out in that column. How can that be?

Is there an easy when of reloading that 1 CSV file into the Combined table?

swb128

[MasonMA · Accepted solution]

@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.

[swb128]

Is there an easy/recommended way of getting the correct data loaded in? There are 1000 rows of data in the file, but just 1 column has been corrupted.

swb1

[MasonMA · Accepted solution]

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? 

[v-pgoloju]

Hi @swb128,

Unfortunately, there's no fully automated solution within Power BI that dynamically adjusts the sample file selection or transformation logic across varied source structures during the "Combine Files" step. Since Power Query builds all subsequent steps based on the structure of the first file.

Thanks & Regards,

Prasanna Kumar

[danextian]

Hi @swb128 

Have you checked in Data view whether ListPrice column is not blank? It is possible that while they are in Excel, your transformations have caused this column to become blank. If it isn't blank, there may be other reasons and it would be easier for us if you provided a sample pbix (confidential data removed) so we can have a look. You may post a link to a file stored in the cloud. 

[Abhilash_P]

Hi @swb128 ,

1. Does all other colulmns ( Community, SoldPrice, Baths, e.t.c ) apart from List are from same table or diffrennt talbe
2. If other columns are from different table can you please share the screenshot of datamodel

Thanks

[MasonMA]

Hi,

It would help if you can share a sample file or part of your data that are not restricted for diagnosis. but if not, based on your update AI provides below:

"1. Check Data Type Consistency

Even though it’s listed as Whole Number, verify that Power BI has applied the correct type after loading from Power Query.

• In Power Query: Check that ListPrice is of type Whole Number.
• After Close & Apply: In the Model View, click the column and confirm it’s still Whole Number.

If it’s mistakenly treated as text (sometimes Power BI guesses incorrectly), you may get blanks.

2. Missing Relationships

If the 'ListPrice' field comes from a related table, and some rows in your main table don’t have a match in the related table, then those rows will show blanks.

Check your model relationships:

• Go to Model View
• Confirm if 'ListPrice' is coming from the same table as the visual, or from a related table
• Ensure there are no unmatched foreign keys

3. Row-Level Security (RLS) or Visual-Level Filters

Even if you mentioned no filters are applied, check:

• Filters pane for visual/page/report level filters.
• RLS roles: Are there active roles restricting data?
• Try creating a new clean table visual with only 'ListPrice' and a row identifier (like ProductID) — this will help rule out filter issues.

4. Data Quality in Excel

Some values might look like numbers but are actually:

• Empty cells with invisible characters
• Non-numeric text like " " or "N/A"

 Try this:

• In Power Query, add a column:

IsNumber = Value.Is([ListPrice], type number)

Filter out false values — this will show which rows aren’t truly numbers.

5. Column Aggregation Settings

When switching from Summarize to Don't Summarize, Power BI should respect that. However:

• If the column is being used in a grouped or aggregated visual, and the value isn't uniquely defined (e.g., multiple rows per cell), it may blank out.
• Try dropping 'ListPrice' into a card visual and see if the values show there.

6. Blank Rows in Visual

The rows with blanks might not actually be coming from the expected table.

• Add a unique ID column to your table visual to ensure the rows you are seeing actually belong to the dataset you think they are from.

7. Try Replacing Blank Values

You could also use a calculated column to force visibility:

VisibleListPrice = 
IF (
    ISBLANK('YourTable'[ListPrice]),
    -1,  -- or any placeholder
    'YourTable'[ListPrice]
)

Then see if -1 appears in the blank areas — this confirms it's a true blank."

[swb128]

Hi Elena,

Thanks for responding! Looking at your possible solutions:

1. Data type mismatch: My screenshot doesn't show the whole table as there are over 1000 rows, but the excel file has values for 'ListPrice' in every row. The data type is WholeNumber for the 'ListPrice' column. Some how the 'ListPrice' shows for some rows, but not for others. Don't know why?

2. Aggregation: Initially the table was doing summurizing on this column and then I went to Format and changed it to 'Don't Summarize'. Not sure if this causes an issue?

3, Hidden Zero: I have filters for my visual, but currently am not applying any filters and the issue is occuring.

4. Measure Logic: 'ListPrice' is not a Measure, it should be showing the values directly from the Excel File. Looking in 'Transform Data', I am able to see a value in the 'ListPrice' column for each of the rows.

swb128

[Elena_Kalina]

Hi @swb128 

Without seeing your actual report, it’s a bit tricky to pinpoint the exact cause, but here are the most likely explanations:

1. Data Type Mismatch Power BI might interpret the ListPrice column as text instead of a numeric format (or vice versa).

2. Aggregation Setting The table could be applying an aggregation (e.g., SUM/AVERAGE) that skips zeros.

3. Hidden Zero Values A visual-level filter or conditional formatting rule might be hiding zeros.

4. Measure Logic If ListPrice is a calculated measure (not a direct column), the DAX formula could be returning blanks.

[swb128]

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