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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
RE
Helper I
Helper I

Date Table Not Rendering On Axis

I have a relationship between two tables, one of which is a date table. I wrote a measure as follows: 

 

Open Tasks =
CALCULATE(
[Number of Tasks],
TaskSet[Status]="Open",
USERELATIONSHIP(TaskSet[Due Date], DateTbl[Date])
)

 

However when I use the date field as the axis it appears blank (see image below) despite there being data in the 'due date' field. Anyone know what could be tripping this up? 

 

date axis blank.PNG

 

6 REPLIES 6
Sean
Community Champion
Community Champion

Are you using a Date Hierarchy? Try clicking Expand ALL - what happens then?

Those are the down arrow buttons in the top left corner of the chart.

 

Also try switching to Date instead of the Date Hierarchy?

I did all of the things you suggested and still no luck. 

Phil_Seamark
Microsoft Employee
Microsoft Employee

Any chance you can upload a stripped down version of the file so we can try a few things?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Unfortunately not, stripping it down wouldn't be feesible. 

Anonymous
Not applicable

Hi @RE,

What is the original format of date values in TaskSet[Due Date] and DateTbl[Date]? Could you please share sample data of your tables which I can test with?


Thanks,
Lydia Zhang

Phil_Seamark
Microsoft Employee
Microsoft Employee

Something to check first is to double check the datatypes used by both Date columns and make sure they are the same?

 

Other than that can you post a small amount of data showing the two tables?  Will make it easier to recreate to suggest ideas.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors