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 visualization does not work.

How can i fix that?

Please see the screenshots below and PBIX file in the link : Link 


Thank you.

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.