Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 data?
I have created the measure exactly as described, but it still doesn't work. I don't understand how it can populate the cells where there are no rows in the original source data.
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.
@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.
@AndrewPF Take your measure and add +0 to the result that is returned.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 25 |
| User | Count |
|---|---|
| 124 | |
| 87 | |
| 70 | |
| 66 | |
| 65 |