Graph showing values in Blank category

[jonzw]

Hi, I have been building a graph of quantities issued vs planned and can't seem to get the issued values to align with the dates.  I have a date table set-up, and relationships built, but the issued values keep showing up in a "Blank" catagory.... like they are no associated with any date.  the x axis is set to catagory and I'm using bins for the dates

Any ideas what I'm doing wrong?

[jonzw]

I tried the above but didn't seem to work.

I think its a relationship issue, this is how it looks with the no relationship to the date table: (btw the "issued" values are supposed to be different values by date not 904.1 accrss all dates)

and this with the relationship restored between my dataset and the date table:

there is some issue with my data and the dates, just can't figure out what

[Greg_Deckler]

@jonzw - Can you post sample data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[GregGiamz]

Hi all, would like to ask on a similar question.
I had linked the data via this 'date' field in my calendar datatable: 

The date in the following datatable which I linked to also had a date format.

I have checked my data, but there is no blank dates.

Hence I'm not sure why it shows as blank in below chart:

Using the following filter does not help:

Any help would be appreciated, thank you!

[jonzw]

here is my data, its filtered on only ST in [DwgDiscipline] and only non blank entries for [Key Quantity], otherwise there are 1,000s of enties

DwgRevInt	DwgDiscipline	Area	Key Quantity	Key Quantity Issued	DwgIssue
	ST	06	4.5
1	ST	CARa	206.6		4/2/2020 21:23
0	ST	CARa	206.6	206.6	3/10/2020 4:21
0	ST	CARb	183.6	183.6	3/13/2020 3:29
E	ST	CARb	175.4		12/24/2019 3:35
E	ST	CARc	17.2		3/6/2020 2:23
0	ST	CARd	143.1	143.1	3/2/2020 21:53
0	ST	CARe1	79.9	79.9	1/19/2020 0:08
0	ST	CARe2	89.4	89.4	1/19/2020 0:08
0	ST	CARe3	109.2	109.2	1/19/2020 0:08
0	ST	CARf	17.0	17.0	1/19/2020 0:08
E	ST	CARh	47.4		3/2/2020 3:41
0	ST	CARh	47.4	47.4	3/22/2020 21:57
E	ST	CARk	8.2		3/25/2020 5:03
0	ST	CARm	5.4	5.4	3/3/2020 17:44
0	ST	CARm	1.5	1.5	3/16/2020 3:59
E	ST	CARm	1.5		3/9/2020 5:20
0	ST	CARm	0.4	0.4	2/5/2020 21:07
E	ST	CARm	13.6		3/9/2020 5:20
0	ST	CARm1	7.4	7.4	1/19/2020 0:08
0	ST	CARm2	5.8	5.8	1/19/2020 0:08
0	ST	CARm3	7.4	7.4	1/19/2020 0:08
E	ST	CARn	47.0		3/30/2020 1:35
	ST	90	0.7

[jonzw · Accepted solution]

I fixed it, it was the date format in my data query, it included time so my date table couldn’t match it. I changed data query to only date and it worked.

[amitchandak]

@jonzw 

1 .If you are using a common date table. Seem like date table does not have the dates needed.

2. Or The issued date has timestamp and not joining with date

Create a new column Date column

Issue Date 1 = [issue Date].date