Forum Discussion

Frequent Visitor

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!

Dshami
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

3 Replies

danextian
Super User
3 years ago
Hi Dshami ,

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
- Dshami
  Frequent Visitor
  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 Dshami ,
    
    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.