I'm new to Power BI. I have a Matrix with Budget vs Actuals plus encumbered amounts. The Budgt, Actuals, and Encumbered columns are from a direct query. The last two columns are calculated measures. I have amounts in the Budget column that are not showing. Those rows do not have amounts in the Actual or Encumbered columns. I'm guessing it's a relationship issue but I have not been able to figure it out. It's almost like if the row doesn't have an amount in the Actual column then its not showing the related budget amount. Thanks Jon!
Hi @Anonymous
You may try to click 'Show items with no data' as below.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
Regards,
Hi @Anonymous
You may try to click 'Show items with no data' as below.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
How to Get Your Question Answered Quickly
Regards,
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
