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 (77)
RE: Improve Direct Query Date Time Handling
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.
RE: Improve Direct Query Date Time Handling
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.
RE: Improve Direct Query Date Time Handling
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?
RE: Improve Direct Query Date Time Handling
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.
RE: Improve Direct Query Date Time Handling
This is frustrating. Dates are a key element for all our dashboards!
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.