Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data Weird Problem

Hello,  I have a problem using power BI direct quiery. I'm working with data date, and even if in power BI editor quiery the values are recognized as a date, when I use the data for the creation of...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    There is no built-in date hierarchy when use DirectQuery. You may try creating a hierarchy manually as below.

    Temp:

     

    You may create two calculated column as below.

    Year = YEAR([Date])
    Month = MONTH([Date])

     

    Then you could right-click the 'Year' column=>'new hierarchy'=>drag 'Month' column into the hierarchy.

     

    Result:

     

    Best Regards

    Allan

     

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

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, Anonymous 

 

There is no built-in date hierarchy when use DirectQuery. You may try creating a hierarchy manually as below.

Temp:

 

You may create two calculated column as below.

Year = YEAR([Date])
Month = MONTH([Date])

 

Then you could right-click the 'Year' column=>'new hierarchy'=>drag 'Month' column into the hierarchy.

 

Result:

 

Best Regards

Allan

 

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