Problem with data display after updating

Hi Syndicate_Admin 

If the columns appear in table view but don't show up in visualizations, it definitely indicates that something in the data model relationships or filter context isn't working properly.

The root cause could be:

• a relationship that isn’t correctly set up,

• a visual/page/filter-level filter affecting visibility,

• a DAX formula that alters the context,

• or an issue in the values themselves – for example, hidden spaces in the new department names.

If the column you added is a key column (used to relate tables), I recommend applying Text.Trim to it in Power Query before loading it to the model – this can eliminate hidden whitespace issues.

To assist further, it would help to see the PBIX file and the relevant Excel data. You can share only the necessary parts through any public cloud service.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi Syndicate_Admin , 

Thanks for reaching out to the Microsoft fabric community forum.
Ritaf1983 

Thanks for your prompt response
Syndicate_Admin 

No matching related values (relationship issue)
Even if the values look the same, check that the department values match exactly between both tables:
Watch out for extra spaces, e.g., "HR" vs. "HR " or " hr".
Also check for case sensitivity if your data source is case-sensitive.
Fix:
In Power Query, use Trim and Clean on the department columns in both tables to remove extra spaces/characters:
Select the column → Transform → Format → Trim and Clean.

Missing related data (LEFT join behavior)
If your table uses a relationship where the related table (e.g., Departments Table) doesn’t have a matching row for the new departments, the data may be excluded from visuals like tables or matrices. Fix:
Make sure both tables have identical and matching entries for the new departments.
Check that the relationship is active, and it’s the correct direction (e.g., many-to-one from your fact table to your departments table). Report-level, Page-level, or Visual-level filters
You said you checked filters, but it’s worth checking all 3 levels:
Report-level filters (in the Filter pane, click the report canvas and see).
Page-level filters.
Visual-level filters (click on the visual and inspect filters in the Filter pane).
Fix:
Remove all filters temporarily to see if the departments appear.
Visual or Measure logic excludes them
If you’re using measures, maybe your measure logic is ignoring rows with blank or zero values.
Fix:
Try a basic visual using raw columns only (no measure), like just placing Department and Amount.
If you use a measure like SUM(Amount), add a filter to include blanks or 0s if necessary.
Data type mismatch
Check that the column data types for the related department fields are both text.
Aggregation suppressing display
If you're using a matrix or table visual, Power BI sometimes hides categories with no data.
Fix:
Go to the visual settings and enable Show items with no data:
Click on the field in the Values or Rows section → right-click → select Show items with no data.

If this post helped resolve your issue, please consider giving it Kudos and marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.