Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Date hierarchy

hi, wanted to ask when i can change the date view to date hierarchy (when clicking on the arrow on the visual edit: values-date )there is sometimes option to select date hierarchy, when? maybe this...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

If the column is recognized as a Date or Date/Time type, then you should have that option. Either that is not supported in DirectQuery or for some reason it is not recognizing it as a Date or Date/Time type, perhaps Text?

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

the column is date of course

 

thanks

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    MP_123

     

    As I tested in direct query mode, when a date field is already in a hierarchy, it will populate entire hierarchy will all level fields into visual if you click on a date field. Otherwise, it will show a single date field only, even the data type is recognized as date.

     

    Regards,