Forum Discussion
Power BI Table Not Displaying Null Values
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.
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
2 Replies
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
Could you share a picture of your relationship or data model?
