580
When using direct query you should be able to change a date axis to show only the month. This works using excel or when doing a transform but neither of these are possible using DirectQuery. Even workarounds like FORMAT can't be used with direct query. This really needs fixing!
STATUS DETAILS
Needs Votes

Comments

S

Agree, please fix this soon or I will be forced to use tableau :(

S

Auto hierarchy would be a huge benefit.

S

Auto creating the hierarchy would be nice too.

S

Please fix this soon.

S

Please add this feature, it would be really handy.

S

This request is represented twice (https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16835431-automatic-date-hierarchy-for-direct-query-data), and both register a high number of votes. Please consider this in the next prioritization cycle, as this is foundational functionality.

S

This feature is much needed. Please make it happen!

S

Totally agree with this

S

Totally agree with this. I just spent half a day trying to hack a way to do this, only to find it was the direct query killing things.

You're gonna have to add this if you want to claim you support interactive analytics.

S

Please add DATE HIERARCHY in Direct Query mode. This is crucial for me. Apart from that there is no functionality with creation of quick measure using Time functions (calculate year over year diff and so on)