topic Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date in DAX Commands and Tips

Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

proavinash — Mon, 26 May 2025 15:34:21 GMT

Date Hierarchy auto convert into normal date despite of i have already check the option of auto date/time in time intellegence feature in Power bI

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

maruthisp — Tue, 27 May 2025 01:07:42 GMT

Hi proavinash,

Even if you have Auto Date/Time enabled, sometimes the hierarchy disappears if you use the wrong column type or don’t mark your date table. Always use a proper date table, mark it, and drag the date field into your visual to get the hierarchy back. If it still doesn’t work, check that your column is the “Date” type and not text.

Please let me know if you have any questions.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!

Best Regards,

Maruthi

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/

X - Maruthi Siva Prasad - (@MaruthiSP) / X

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

grazitti_sapna — Tue, 27 May 2025 06:49:35 GMT

Hi proavinash

Checklist to Ensure Date Hierarchy Works
1. Auto Date/Time enabled in BOTH places:

From your screenshot, you’ve correctly enabled:

GLOBAL > Data Load > Time intelligence > Auto date/time
CURRENT FILE > Data Load > Time intelligence > Auto date/time

2.Check if your column is actually of Date or Date /Time type:

Right-click on the column in Power BI Desktop → Column Tools → ensure the Data Type is set to Date or Date/Time.
If it's Text or Whole Number, Power BI won’t generate a hierarchy.

3.Check visuals – is it a Table, Matrix, or other

Certain visualizations might show dates flat unless you explicitly expand the hierarchy.
In visual, click the dropdown on the field → select Date Hierarchy instead of just Date.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

proavinash — Wed, 28 May 2025 17:16:52 GMT

format already selected date, the problem is every time when open power bi desktop it convert to date hierarchy , i every time correct this and change it to hierarchy and save but when i open it again , it shows normal date , date hierarch is disappear.

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

v-sathmakuri — Thu, 29 May 2025 16:25:26 GMT

Hi proavinash ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you grazitti_sapna and maruthisp for the prompt response.

If Power BI is automatically converting your date field into a flat date instead of showing it as a hierarchy, you can resolve this by creating a dedicated Date table using the following DAX

DateTable =
ADDCOLUMNS (
CALENDAR (DATE(2020, 1, 1), DATE(2030, 12, 31)),
"Year", YEAR([Date]),
"MonthNumber", MONTH([Date]),
"MonthName", FORMAT([Date], "MMMM"),
"Quarter", "Qtr" & FORMAT([Date], "Q")
)

Establish a relationship between the Date column in your main table and the Date column in the DateTable.
Use the fields from the DateTable (such as Year, Quarter, Month) to create and display a custom date hierarchy in your visuals.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank you!!

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

v-sathmakuri — Mon, 02 Jun 2025 09:08:25 GMT

Hi proavinash ,

May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

v-sathmakuri — Thu, 05 Jun 2025 11:41:16 GMT

Hi proavinash ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!

Re: Date Hierarchy auto convert into normal date despite of i have already check the option of auto date

v-sathmakuri — Sun, 08 Jun 2025 18:23:50 GMT

Hi proavinash ,

I hope the information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!