Missing column and Row Values in heatmap

[muhamazh]

Hello everyone,

I am facing the problem of missing columns and rows in the heatmap.

I have 8 categories for which I need to draw the heatmap.

Let's say they are A B C D E F G H

I can only create the following

              A             D

B            1             2

C            3            4

D           5             6

Because there are no other existing values for the other columns/rows, and they don't show up.

I want to make my heatmap look like the one below despite having no values for the others and filling them up with 0

              A         B         C         D         E           F            G            H

A            1         2         0         0          0          0            0               0

B            3         4         0          0          0       .................  

C            ........

D

E                   Zeros everywhere here

F

G

H

How can I show the heatmap like this?? Thanksss

Edit:  Problem was solved by just adding the measure I wrote by 0 . Like A[X] + 0 . Thanks

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.