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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Fab117
Helper IV
Helper IV

Date are automatically split in year/Quarter/Month/Day

Hi,

I'm using table with dates [TaskFinishDate]. View in Transform Data mode:

01 TskFinnishDate.png

 

In Desktop, I can see that [TaskFinishDate] is split in "Year", "Quarter", Month" and "Day":

02 Fields.png

 

And then, if I use this field in a Table, dates are split:

03b Fields in table.png

03 Report.png

 

How can I have "standard" dates (in Eu format) in one column: e.g.: "15.12.2023"?

 

Thanks

 

Fab

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Fab117 ,

 

mussaenda_0-1666870808291.png

 

based on the screenshot, you right click the column of the date,

the select date instead of Date Hierarchy.

 

That will solve your issue.

 

Hope this helps.

 

View solution in original post

2 REPLIES 2
Fab117
Helper IV
Helper IV

Thank you very much.

Solved.

 

Have a nice end of the day.

 

Fab

mussaenda
Super User
Super User

Hi @Fab117 ,

 

mussaenda_0-1666870808291.png

 

based on the screenshot, you right click the column of the date,

the select date instead of Date Hierarchy.

 

That will solve your issue.

 

Hope this helps.

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors