Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Matrix visual

If my matrix visuals has certain columns that do not have values, then how do I show them as zero?

Thank You!

Anonymous
7 years ago
In your calculated measure/ column formula. Just add +0 in the end.

Thanks
Raj
Anonymous
7 years ago
Hi Anonymous

I think you are pulling ID from table and setting count in the "Fields" Tab. Instead, i would recommend to create a measure COUNT(Table1[ID]) +0 and use it in the matrix , which is the best practice so that it will help you in any futue measure branching as well.

Thanks
Raj

6 Replies

Anonymous
Not applicable
7 years ago
Use Column+0 in formula.

Thanks
Raj
- Anonymous
  Not applicable
  7 years ago
  Anonymous Hey where to give that?
  - Anonymous
    Not applicable
    7 years ago
    In your calculated measure/ column formula. Just add +0 in the end.
    
    Thanks
    Raj

Related content