Forum Discussion
Date hierarchy on column
Hi aas_nordea,
Please change your [Agreement Effective Date] data type to "Date" in the column tools, and then you should be able to see automatic date hierarchy which you can put them into the slicer.
If you don't find automatic hierarchy for your date column, please try to tranform it in the Power Query editor or refer to below artical: https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682
Best Regards,
Joyce
Solution SupplierHi aas_nordea,
Please change your [Agreement Effective Date] data type to "Date" in the column tools, and then you should be able to see automatic date hierarchy which you can put them into the slicer.
If you don't find automatic hierarchy for your date column, please try to tranform it in the Power Query editor or refer to below artical: https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682
Best Regards,
Joyce