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
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,