570
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

Coming from tableau I tried for several hours trying to figure out why date hierarchy wouldn't show up. Disappointing that such a basic reporting need is not built in yet.

S

Tableau has natively this option in it "Direct Query"...

S

Please fix this!

S

This creates a large amount of extra work for everyone using DirectQuery - which I would assume is the vast majority of users.

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