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
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
