topic Re: Report needs to show nulls in Custom Visuals Development Discussion

Report needs to show nulls

CluelessNewbie — Sun, 27 Oct 2024 21:36:54 GMT

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?

Re: Report needs to show nulls

lbendlin — Sun, 27 Oct 2024 21:43:03 GMT

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

Re: Report needs to show nulls

CluelessNewbie — Sun, 27 Oct 2024 22:34:06 GMT

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