Forum Discussion

Ria's avatar
Ria
Frequent Visitor
10 years ago

Date Hierarchy

Sometimes when I create a visualization in Power BI desktop with date and sales data, it automatical sets it up with the date hierarchy.  I had one visualization set up this way and then added a new ...
fedin's avatar
fedin
Regular Visitor
9 years ago

Sorry if doing this wrong as this is my first time here :).

 

Indeed the problem appears when you add the date column to a relationship. Assume I had a table called "theTable" with a date column called "DateCol". My solution was to create a new calculated column "DateCol2 = [theTable]DateCol" and then replace DateCol with DateCol2. Using DateCol2 I got my hierarchy back.