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 (72)
RE: Improve Direct Query Date Time Handling
Submitted in 2016, 650+ votes. Come on, Microsoft!
RE: Improve Direct Query Date Time Handling
Why is this not standard, seems ludicrous
RE: Improve Direct Query Date Time Handling
It's May 2023 and still this most useful feature with Import mode is not standard in Direct Query.
RE: Improve Direct Query Date Time Handling
Should really be standard
RE: Improve Direct Query Date Time Handling
This would be a very useful feature.
RE: Improve Direct Query Date Time Handling
How is it even possible that this isn't automatic?!?!?!?
RE: Improve Direct Query Date Time Handling
Very much needed! - workarounds don't work at all or have not the same functionality, please make this a feature
RE: Improve Direct Query Date Time Handling
6 years pass by and people are still looking for this feature. Why isn't it implemented.
RE: Improve Direct Query Date Time Handling
Coming from tableau I tried for several hours trying to figure out why date hierarchy wouldn't show up. Disappointing that such a basic reporting need is not built in yet.
RE: Improve Direct Query Date Time Handling
Tableau has natively this option in it "Direct Query"...