Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to 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
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 36 | |
| 32 | |
| 31 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |