Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix: Missing Values

I am having an issue with the Matrix visual where the sub-total shows an amount but when you drill down, there are no values showing.     Any help is appreciated, thank you very much.
Need Help
rafaelmpsantos's avatar
rafaelmpsantos
Responsive Resident
7 years ago

I really can't see what is causing this problem.

Sales is a measure or a columns? if a column try change it for a measure like sum(sales)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sales is a column.  I tried it as a measure but it is still blank.

 

What is weird is when I uncheck "Show items with no data", they show up just fine.

 

I really don't want to go that route, but it looks like it is the only solution for now.

 

 

Thanks again for the time rafaelmpsantos.  

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    Due to I could not reproduce your problem, could you please share your sample file to have a view?

     

    Regards,

    Daniel He