Forum Discussion

venkatasuresh_g's avatar
venkatasuresh_g
Icon for Helper IV rankHelper IV
2 years ago
Solved

Hierarchies in Tables when using Direct Lake mode

Hi    I  built a semantic model in fabric on Data Lake, I have a date table for which I was expecting to see Date hierarchy but I don't see one and I don't have an option to add hierarchy in on the ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi venkatasuresh_g 

     

    As mentioned hierarchies are not currently supported in DirectLake

venkatasuresh_g's avatar
venkatasuresh_g
Icon for Helper IV rankHelper IV
2 years ago

Hi GilbertQ  , Thanks for your response , When I drag year and Quarter to Y Axis it does show Hierarchy but the problem is at Quarter level it does merge Querter from all years together 

Data I have 

 

Visual 

 

 

Formatting in Visualization 

 

 

you can see Q1 it added 2023 and 2024 together 

 

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    Hi venkatasuresh_g 

     

    Could you make sure that the Year column default setting is set to None and not to SUM?

    • venkatasuresh_g's avatar
      venkatasuresh_g
      Icon for Helper IV rankHelper IV
      2 years ago

      Hi GilbertQ ,

       

         Year column is already set to null as shown in below image 

      It seems Microsoft just added Hierarchy option in Semantic model. I did not see that this morning but I see it now. 

       

       When I drill down from year to QTR it works fine as I did drill in to one year , when I drill in to next level using double down arrow , that is when QTR is being grouped. 

       

      Thanks 

      Suresh 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thanks GilbertQ solution

        Hi,  venkatasuresh_g 

        Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

         

         

        Best Regards

        Jianpeng Li