Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix Visual - Show Blank Values as Zero

Hello,   I'm using a matrix visual with many columns.  I would like to show blank values as zero.  In Excel, there is a simple option checkbox for this, but I can't seem to find any equivalent in P...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi mstone3,

     

    If you want to show blank value  as zero like below

    You could use expression like below

    Column= marix[amoaunt]+0

    If you want to fill blank area with zero in matrix like below

    Because the records don’t exist in dataset, so it will show blank. So you need to create a related table like below

    Use this filed in Matrix, then create measure like below

    Measure 7 = SUM(marix[amoaunt])+0

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
7 years ago

Hi mstone3,

 

If you want to show blank value  as zero like below

You could use expression like below

Column= marix[amoaunt]+0

If you want to fill blank area with zero in matrix like below

Because the records don’t exist in dataset, so it will show blank. So you need to create a related table like below

Use this filed in Matrix, then create measure like below

Measure 7 = SUM(marix[amoaunt])+0

Best Regards,

Zoe Zhi

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.