Improve Direct Query Date Time Handling

[PowerBIIdeas]

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!

[gareth_jones]

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

[Nate_Auchter]

Please fix this!

[dherrera]

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

[Dylan_Stewart]

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.

[Katy_Yeung]

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

[fbcideas_migusr]

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

[mike59]

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

[knelson2]

This would be a very useful feature.

[connor_doherty1]

Should really be standard

[tristan1]

It's May 2023 and still this most useful feature with Import mode is not standard in Direct Query.