Power BI Table Not Displaying Null Values

[debkops]

Hello,

I have created a simple table displaying the project name, values, dates and the associated Architect on the project. I am noticing that the table view is only displaying records when the project has an Architect populated; null values are not displaying on the report. I hope the community will be able to provide any guidance to what hopefully is a simple fix! Thank you.

[v-yiruan-msft · Accepted solution]

Hi @debkops ,

Please check the method in the links below, and try it later to see if they can resolve your problem.

1. Change the default aggregation "Sum" to "Don't Summarize"

How to Include the records that have NULL value in one of their fields at Power BI Table Visual?

2. Enable the Show items with no data feature

Show items with no data in Power BI

If the above ones are not woring, please provide some sample data in your simple table and the setting of Fields pane for your table visual. Thank you.

Best Regards

[rodrigosan]

Could you share a picture of your relationship or data model?