Skip to main content
cancel
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.

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


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

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

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

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.