612
S

Improve Direct Query Date Time Handling

Sam Bloggs on 6/14/2016 9:06:14 PM
612
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

S

RE: Improve Direct Query Date Time Handling

Mike Hapner on 1/4/2023 6:40:59 PM

How is it even possible that this isn't automatic?!?!?!?

S

S

RE: Improve Direct Query Date Time Handling

Sebastian Stadler on 10/27/2022 3:13:06 PM

Very much needed! - workarounds don't work at all or have not the same functionality, please make this a feature

S

S

RE: Improve Direct Query Date Time Handling

Katy Yeung on 10/4/2022 3:19:14 AM

6 years pass by and people are still looking for this feature. Why isn't it implemented.

S

S

RE: Improve Direct Query Date Time Handling

Dylan Stewart on 5/9/2022 3:42:10 PM

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.

S

S

RE: Improve Direct Query Date Time Handling

Diego Ernesto Herrera Malambo on 5/5/2022 7:22:29 PM

Tableau has natively this option in it "Direct Query"...

S

S

RE: Improve Direct Query Date Time Handling

Nate Auchter on 3/23/2022 11:32:45 PM

Please fix this!

S

S

RE: Improve Direct Query Date Time Handling

Gareth Jones on 2/14/2022 5:14:42 AM

This creates a large amount of extra work for everyone using DirectQuery - which I would assume is the vast majority of users.

S

S

RE: Improve Direct Query Date Time Handling

Paula Leger on 10/6/2021 4:14:51 PM

Date hierarchy using direct query should have been available from beginning considering how most database data is reported. You shouldn't have to rely on a voting system, waiting for others to realize that this is a big problem.

S

S

RE: Improve Direct Query Date Time Handling

Tristan Ozinga Ozinga on 5/6/2021 9:40:17 AM

I can't believe this functionality is not natively available. The work around of creating new columns and using DAX time functions is laborious to say the least! PLEASE MAKE THIS FEATURE!

S

S

RE: Improve Direct Query Date Time Handling

Timothy Fooks on 5/6/2021 5:20:55 AM

Another comment - because this really needs to be done.