Date hierachy not working

Question

Hi,&nbsp;I have a column from a Sharepoint list that is 'Date of Enquiry'. In one report it shows as a hierarchy but in another it does not.&nbsp;The one where it does not has a Calendar Table with a 'Date' field. These 2 dates have a relationship but it isn't active as it would cause ambiguity with another connection.&nbsp;How do I get the Date of Enquiry column to have a hierarchy?&nbsp;Thanks

amitchandak · Accepted Answer

Slumpig , If You create a calendar table and marked it as date table. The key date column will lose hierarchy. And the date column joined to that date will also lose that. You can create a custom hierarchy 
&nbsp;
These are the reasons Date Hierarchy can be missinghttps://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
&nbsp;
Custom Hierarchy https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/https://www.youtube.com/watch?v=x6vXVJZ_eTY

Forum Discussion

Date hierachy not working

2 Replies

Related content

Date Hierachy

RANKX with date hierachy and column charts

Create Date Hierachy

Missing Date Hierachy Lakehouse Model

Date Hierachy