Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a date field that not generates hierarchy, while I have other date fields thast generate hierarchy..how can I do?
Thank you
Solved! Go to Solution.
@Giada_Togliatti , If you have an auto datetime checked (in options and setting) then you should get the date hierarchy.
But if it is a key field, you might miss that
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Hi @Giada_Togliatti ,
it is highly recommended to use your own date table as a dimension and to switch off the automatism of hierarchy formation for columns with date values (see figure).
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
@Giada_Togliatti , If you have an auto datetime checked (in options and setting) then you should get the date hierarchy.
But if it is a key field, you might miss that
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045