Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Direct Query | Datetime columns don't have hierarchy

Hello everyone,   I'm creating a dashboard using a direct query from a sql server view.   Problem: I have several columns (datetime) and PowerBI recognizes them as so but it doesn't show the ico...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Regarding the cause of this problem, you can refer to this:

    Modeling limitations 

     

    But you can create hierarchical dates manually.

    First, creating [Year], [Quarter], [Month], [Day]  calculated column. ( You need to use YEAR(), QUARTER(), MONTH(), DAY() function)

    Second, select the three points to the right of the column.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Regarding the cause of this problem, you can refer to this:

Modeling limitations 

 

But you can create hierarchical dates manually.

First, creating [Year], [Quarter], [Month], [Day]  calculated column. ( You need to use YEAR(), QUARTER(), MONTH(), DAY() function)

Second, select the three points to the right of the column.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.