Power BI - Date in Data type

[JorgeRodGom]

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?

[Anonymous · Accepted solution]

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.           

[JorgeRodGom]

I resolved it by selecting "Import" instead of "Direct Query" under data connectivity mode

[JorgeRodGom]

Hi!

Even if I create the data hierarchy, I don´t get the day, month, year information:

[Anonymous]

If you change it in Power Pivot instead in transformation page what it is showing

[Idrissshatila]

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💡