Forum Discussion

AndrewPF's avatar
AndrewPF
Helper V
3 years ago

adding zero values to a matrix heatmap

I have created a heatmap from a matrix:      but I want the squares without values to have zeroes.    Is there any way of accomplishing this, other than adding "zero" rows into my test dat...
Need Help
AndrewPF's avatar
AndrewPF
Helper V
3 years ago

I don't think I understand.  I don't have any rows in my data where, for example, Impact = "4 - Likely" and Likelihood = "4 - Severe".  The values are just COUNT = 1 on each row in the source data and I am summing them in the matrix with Impact as the X-axis and Likelihood as the Y-axis.  Creating a new [COUNT] + 0 measure won't create any values where there are no existing values. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    AndrewPF Create a measure:

     

    Measure = SUM('Table'[COUNT]) + 0

    For the blank areas, the sum will return BLANK and then when 0 is added, you get 0. Adding zero to sums that return numbers (not blank) does not change the number.