Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |