Forum Discussion

Egemeny's avatar
Egemeny
Frequent Visitor
4 years ago
Solved

Data Hierarchy dissapears when established connection between two data tables

Hi everyone, I need your support. I do have two tables that contain date hierarchy and when I try to create relationships between them, one of the hierarchies disappears and as a result, my vis...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Egemeny ,

     

    The reason why the date hierarchy will still not be visible is the table is marked as a date table. This blog explains in detail.

    Why there is no date hierarchy - Microsoft Power BI Community .

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Egemeny , when you join a date with a date/calendar table marked as date table. You will lose hierarchy. My advice would be to create a required column in the date table.

 

Or create another column of that date

 

date1 = [Date]

 

this new column will have hierarchy