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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Abdullah64446
New Member

Date break up

Hello everyone,

 

I am using power Bi desktop and I am trying to break the date into( Year,month,day)

 

It looks like this now 👇

q.png

 

But I want it to looks like this 👇

qq.png

 

Please help. Thank you 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You do that by enabling auto date/time.  Note that this is not considered best practice.  Better to use a calendar dimension table in your data model.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

You do that by enabling auto date/time.  Note that this is not considered best practice.  Better to use a calendar dimension table in your data model.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors