580
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

Yeah.
I am using weird alternative for this.
It would be nice to see that feature added.

S

This is a requirement for working with larger data sets. Having no ability to work on date fields in DQ by using custom field is not a good experience.

S

I completely agree and second that DQ needs to support Date Hierarchy

S

Date hierarchy needs to be available in Direct Query mode in addition to Import mode.