Forum Discussion
Power BI - Date in Data type
My Date column has Data type "Date" in transform data:
However, when it comes to the Data in the report view it does not appear as "Date" :
Because of this, I cannot filter by quarter, month, year in my visualizations.
How can it be fixed?
Hi JorgeRodGom ,
Currently, the built-in date hierarchy is not yet available when using DirectQuery mode.
As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.
Simliar post:
Solved: Date Hierarchy in Direct Query - Microsoft Fabric Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
I resolved it by selecting "Import" instead of "Direct Query" under data connectivity mode
- Idrissshatila
Super User
Hello JorgeRodGom ,
check this blog to learn how to build a data hierarchy https://zebrabi.com/advanced-guide/how-to-make-date-hierarchy-in-power-bi/
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡 Hi!
Even if I create the data hierarchy, I don´t get the day, month, year information:
Hi JorgeRodGom ,
Currently, the built-in date hierarchy is not yet available when using DirectQuery mode.
As a workaround, you could create a custom date hierarchy manually. Please create [Year], [Quarter], [Month], [Day] columns first, right-click the original Date column and choose 'New Hierarchy', then, drag [Year], [Quarter], [Month], [Day] columns to place them under [Date] column.
Simliar post:
Solved: Date Hierarchy in Direct Query - Microsoft Fabric Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
