Forum Discussion

bianchinod's avatar
bianchinod
Icon for Advocate I rankAdvocate I
9 years ago

Date Hierarchy not showing

I have a problem with Date Hierarchy. After the last sw update (Version: 2.40.4554.421 64-bit (ottobre 2016)) it seams that power bi does not show the date Hierarchy. I'm using a direct query c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

This is a frustrating issue. An easy (but frustratingly should-be-unnecessary) workaround is to create a calculated field:

 

DateIShouldntHaveToCreateThisExtraColumn = 'QueryPowerBIIsntReadingRight'[DateFromQueryThatForNoReasonIsntWorking]

The new column should give you a heirarchy without a problem.

 

And, if you're like me, it'll make you mad every time you see the duplication.

  • Shelley's avatar
    Shelley
    Icon for Post Prodigy rankPost Prodigy
    8 years ago

    Same problem. Created unnecessary field with date format and the hierarchy now shows. Very annoying. Thanks!