Sam Bloggs on 14 Jun 2016 21:06:14
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!
- Comments (55)
RE: Improve Direct Query Date Time Handling
Please add DATE HIERARCHY in Direct Query mode. This is crucial for me.
RE: Improve Direct Query Date Time Handling
Agree, please fix this soon or I will be forced to use tableau :(
RE: Improve Direct Query Date Time Handling
Auto hierarchy would be a huge benefit.
RE: Improve Direct Query Date Time Handling
Auto creating the hierarchy would be nice too.
RE: Improve Direct Query Date Time Handling
Please fix this soon.
RE: Improve Direct Query Date Time Handling
Please add this feature, it would be really handy.
RE: Improve Direct Query Date Time Handling
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.
RE: Improve Direct Query Date Time Handling
This feature is much needed. Please make it happen!
RE: Improve Direct Query Date Time Handling
Totally agree with this
RE: Improve Direct Query Date Time Handling
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.