Report needs to show nulls

Question

Hi, I have a Matrix style heatmap where I have 10 categories and 44 total subcategories. My problem is that some of the subcategories have no data and they are not showing up in my heatmap.
I really need them to as that is the point of the heatmap - Showing the items that are blank versus those that have a high number

Looking online the suggested fix of ticking "show items with no data" doesn't solve my issue.
I have added a ranking to all the categories hoping that would help but it hasn't.
Is there something I am missing to make the items show up?

lbendlin · Answer

To report on things that are not there you need to use disconnected tables and/or crossjoins
&nbsp;
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

cluelessnewbie · Answer

Hi, data is somewhat like this within the matrix.The underlying data has rows of data that account for the 'count column' and then there is a lookup that provides the category and sub category and Rank to create the matrix viewRank&nbsp;Category&nbsp;Subcategory&nbsp;Count of coverage items1&nbsp;Category 1&nbsp;Subcategory 1&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;Subcategory 2&nbsp;121&nbsp;&nbsp;&nbsp;Subcategory 3&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;Subcategory 4&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;Subcategory 5&nbsp;&nbsp;2&nbsp;Category 2&nbsp;Subcategory 6&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;Subcategory 7&nbsp;1352&nbsp;&nbsp;&nbsp;Subcategory 8&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;Subcategory 9&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;Subcategory 10&nbsp;393&nbsp;Category 3&nbsp;Subcategory 11&nbsp;8163&nbsp;&nbsp;&nbsp;Subcategory 12&nbsp;3143&nbsp;&nbsp;&nbsp;Subcategory 13&nbsp;343&nbsp;&nbsp;&nbsp;Subcategory 14&nbsp;633&nbsp;&nbsp;&nbsp;Subcategory 15&nbsp;&nbsp;4&nbsp;Category 4&nbsp;Subcategory 16&nbsp;444&nbsp;&nbsp;&nbsp;Subcategory 17&nbsp;284&nbsp;&nbsp;&nbsp;Subcategory 18&nbsp;7884&nbsp;&nbsp;&nbsp;Subcategory 19&nbsp;175&nbsp;Category 5&nbsp;Subcategory 20&nbsp;565&nbsp;&nbsp;&nbsp;Subcategory 21&nbsp;6345&nbsp;&nbsp;&nbsp;Subcategory 22&nbsp;135&nbsp;&nbsp;&nbsp;Subcategory 23&nbsp;&nbsp;6&nbsp;Category 6&nbsp;Subcategory 24&nbsp;176&nbsp;&nbsp;&nbsp;Subcategory 25&nbsp;&nbsp;6&nbsp;&nbsp;&nbsp;Subcategory 26&nbsp;36&nbsp;&nbsp;&nbsp;Subcategory 27&nbsp;&nbsp;6&nbsp;&nbsp;&nbsp;Subcategory 28&nbsp;36&nbsp;&nbsp;&nbsp;Subcategory 29&nbsp;4477&nbsp;Category 7&nbsp;Subcategory 30&nbsp;&nbsp;7&nbsp;&nbsp;&nbsp;Subcategory 31&nbsp;997&nbsp;&nbsp;&nbsp;Subcategory 32&nbsp;298&nbsp;Category 8&nbsp;Subcategory 33&nbsp;1188&nbsp;&nbsp;&nbsp;Subcategory 34&nbsp;4548&nbsp;&nbsp;&nbsp;Subcategory 35&nbsp;&nbsp;8&nbsp;&nbsp;&nbsp;Subcategory 36&nbsp;439&nbsp;Category 9&nbsp;Subcategory 37&nbsp;&nbsp;9&nbsp;&nbsp;&nbsp;Subcategory 38&nbsp;5969&nbsp;&nbsp;&nbsp;Subcategory 39&nbsp;789&nbsp;&nbsp;&nbsp;Subcategory 40&nbsp;435910&nbsp;Category 10&nbsp;Subcategory 41&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;Subcategory 42&nbsp;210&nbsp;&nbsp;&nbsp;Subcategory 43&nbsp;210&nbsp;&nbsp;&nbsp;Subcategory 44&nbsp;10

Forum Discussion

Report needs to show nulls

2 Replies

Related content

Counting nulls

Handling Null Values

Replace Values Null to Blank or Blank to Null

Replace NULL

Null value error

Rank	Category	Subcategory	Count of coverage items
1	Category 1	Subcategory 1
1		Subcategory 2	12
1		Subcategory 3
1		Subcategory 4
1		Subcategory 5
2	Category 2	Subcategory 6
2		Subcategory 7	135
2		Subcategory 8
2		Subcategory 9
2		Subcategory 10	39
3	Category 3	Subcategory 11	816
3		Subcategory 12	314
3		Subcategory 13	34
3		Subcategory 14	63
3		Subcategory 15
4	Category 4	Subcategory 16	44
4		Subcategory 17	28
4		Subcategory 18	788
4		Subcategory 19	17
5	Category 5	Subcategory 20	56
5		Subcategory 21	634
5		Subcategory 22	13
5		Subcategory 23
6	Category 6	Subcategory 24	17
6		Subcategory 25
6		Subcategory 26	3
6		Subcategory 27
6		Subcategory 28	3
6		Subcategory 29	447
7	Category 7	Subcategory 30
7		Subcategory 31	99
7		Subcategory 32	29
8	Category 8	Subcategory 33	118
8		Subcategory 34	454
8		Subcategory 35
8		Subcategory 36	43
9	Category 9	Subcategory 37
9		Subcategory 38	596
9		Subcategory 39	78
9		Subcategory 40	4359
10	Category 10	Subcategory 41
10		Subcategory 42	2
10		Subcategory 43	2
10		Subcategory 44	10