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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

 

PBI.png

Any ideas what I'm doing wrong?

1 ACCEPTED SOLUTION
jonzw
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

6 REPLIES 6
jonzw
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: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

GregGiamz_4-1709717739586.png

 

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:

GregGiamz_1-1709717529916.png

Using the following filter does not help:
GregGiamz_0-1709717499000.png

 

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
 ST064.5  
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
 ST900.7  
jonzw
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.
amitchandak
Super User
Super User

@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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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