Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
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 👇
But I want it to looks like this 👇
Please help. Thank you
Solved! Go to Solution.
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.
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 12 | |
| 7 | |
| 5 | |
| 5 | |
| 3 |