Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix not showing all data

 

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,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee

    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,