518
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

Date hierarchy using direct query should have been available from beginning considering how most database data is reported. You shouldn't have to rely on a voting system, waiting for others to realize that this is a big problem.

S

I can't believe this functionality is not natively available. The work around of creating new columns and using DAX time functions is laborious to say the least! PLEASE MAKE THIS FEATURE!

S

Another comment - because this really needs to be done.

S

Please take a look on this - causes so much re work!

S

Also critical: hierarchy dates for charts!

S

must need option

S

Please look into this ASAP.

S

Please add this! Agree wholeheartedly that Direct Query & Import modes should have the same date handling functionality!!!

S

Please add DATE HIERARCHY in Direct Query mode also. Why there is such a difference in import and direct query mode. Too much difficulty in handling such situation.

S

I do not understand why direct query acts differently than import. This needs to be fixed. I am spending silly amounts of time trying to work around it.