Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Matrix Grand total for column showing zero

I am facing this issue for all matrix visual that row grand totals are working well but column grand totals are showing 0.00. Please help!

Anonymous
3 years ago
The issue is resolved now.
I had a blank row at top in matrix which had huge values.. I removed them from filter pane i.e. excluding blank values from the row values of matrix and it got resolved

Icon for Super User rank

Super User

3 years ago

Hi Anonymous ,

We'd like to help but there's just not enough information. Here's how you can get you question answered quickly:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150

Anonymous
Not applicable
3 years ago
The issue is resolved now.
I had a blank row at top in matrix which had huge values.. I removed them from filter pane i.e. excluding blank values from the row values of matrix and it got resolved
- v-yadongf-msft
  Community Support
  3 years ago
  Hi Anonymous ,
  
  I am so glad to hear that your problem has been solved .
  
  Can you share your solution with us. It's very useful for other members who have the same problem as yours.
  
  And Please consider Accept it as the solution to help other members find it more quickly.
  
  Best regards,
  
  Yadong Fang
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.