Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

Graph showing values in Blank category

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?

Frequent Visitor

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.

View solution in original post

Frequent Visitor

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)

PBI 2.png


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

PBI 2.1.png


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


@jonzw - Can you post sample data? Please see this post regarding How to Get Your Question Answered Quickly:

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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!



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


DwgRevIntDwgDisciplineAreaKey QuantityKey Quantity IssuedDwgIssue
1STCARa206.6 4/2/2020 21:23
0STCARa206.6206.63/10/2020 4:21
0STCARb183.6183.63/13/2020 3:29
ESTCARb175.4 12/24/2019 3:35
ESTCARc17.2 3/6/2020 2:23
0STCARd143.1143.13/2/2020 21:53
0STCARe179.979.91/19/2020 0:08
0STCARe289.489.41/19/2020 0:08
0STCARe3109.2109.21/19/2020 0:08
0STCARf17.017.01/19/2020 0:08
ESTCARh47.4 3/2/2020 3:41
0STCARh47.447.43/22/2020 21:57
ESTCARk8.2 3/25/2020 5:03
0STCARm5.45.43/3/2020 17:44
0STCARm1.51.53/16/2020 3:59
ESTCARm1.5 3/9/2020 5:20
0STCARm0.40.42/5/2020 21:07
ESTCARm13.6 3/9/2020 5:20
0STCARm17.47.41/19/2020 0:08
0STCARm25.85.81/19/2020 0:08
0STCARm37.47.41/19/2020 0:08
ESTCARn47.0 3/30/2020 1:35
Frequent Visitor

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


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


Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.