602
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

Bump. Hope this makes it into the next update!

S

CRUCIAL TO HAVE THIS FEATURE ON !!!
POWER BI IS MOVING TO STREAMING LIVE DATA WHERE DIRECT QUERY IS THE BASE FOUNDATION OF THAT PRINCIPLE. GET LIVE AND UPDATED DATA AS SOON AS YOUR DATABASE CHANGES.
SO HAVING THIS KIND OF LIMITATION ON A BASIC FEATURE IT'S A ANNOYING.

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.