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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Date Column Does not show hierarchy

Hi Team,

 

I have two columns here, both were String from the source and I have transformed them to date, they look like this.

 

Date and Actual.PNG

 

Now when I come to the report side, I see the columns like this. 

actual date.PNGPlan date.PNG

 

I don't understand the issue, but any calculation with using "planned date" gives correct value, and using "actual date" gives the wrong value. 

 

3 REPLIES 3
mwegener
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous ,

 

Is "planned date" related to a date table?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Anonymous
Not applicable

Hi @mwegener , No, both the dates are coming from Source SQL data.

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous ,

 

can you share a screenshot of the data model view?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Helpful resources

Announcements
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