Report needs to show nulls

[CluelessNewbie]

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?

[CluelessNewbie]

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 view

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

[lbendlin]

To report on things that are not there you need to use disconnected tables and/or crossjoins

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-...

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/1447...