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

Yes. This is limiting drill-down capability with Direct Query.

S

Hi PowerBI Team, I'm handling the bulk of time series data, if date hierarchy is available in the direct query, it will be more helpful to us

S

Power BI team, Please consider this feature in the upcoming release.

S

Need this now!!

S

Please add date hierarchy in direct query mode. Thankyou.

S

please add date hierarchy in direct query mode

S

This is very useful tool and not having it on direct query is making reports very hard to develop.

Please correct this problem ASAP.
RL 2/15/2019

S

Totally agree with this. This feature is much needed. Please fix it soon!

S

Please add Date Hierarchy to DQ.

S

Definitely agree