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!

[kit_macInnes-ma]

Why is this not standard, seems ludicrous

[WDrotar]

Submitted in 2016, 650+ votes. Come on, Microsoft!

[Chrysoula_Leled]

This is frustrating. Dates are a key element for all our dashboards!

[janis_berzins]

A must have option. Currently doing this manually year, month, etc shows months not by their name but number. I believe the every user who used Direct Query would benefit from this greatly.

[gvalen]

Agree I'm trying to do simple Dynamics 365 sales analysis in powerbi with direct query. @microsoft maybe add in a calendar into Dynamics 365 CRM/Sales if not?

[federico_airold]

Much needed, should be BASIC for a BI Report system, IMO; to be able to handle datetimes in a comfort way instead of tweaking things arounf.

[Daniel_Blair]

Every other BI tool that I've used does this out of the box. This should be a basic requirement for a reporting tool here in 2024.