Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
venkatasuresh_g
Helper III
Helper III

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 table , is this not possible ? 

 

Thanks 

Suresh 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @venkatasuresh_g 

 

As mentioned hierarchies are not currently supported in DirectLake





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

8 REPLIES 8
joakimfenno
Helper IV
Helper IV

I have the same issue
even thought I mark the table as date table it does not behave as one
Is the solution to avoid direkt lake storage? what is the suggested solution if you want to have another storage mode for specific table?

van you even mix storage modes (I read that direkt lake is a all or nothing for a semantic model)

GilbertQ
Super User
Super User

Hi @venkatasuresh_g 

 

As mentioned hierarchies are not currently supported in DirectLake





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

venkatasuresh_g
Helper III
Helper III

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 

venkatasuresh_g_4-1712517794113.png

 

Visual 

 

 

venkatasuresh_g_1-1712517626330.png

Formatting in Visualization 

venkatasuresh_g_2-1712517660942.png

 

 

you can see Q1 it added 2023 and 2024 together 

 

Hi @venkatasuresh_g 

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ ,

 

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

venkatasuresh_g_0-1712531186669.png

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 

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

 

 

Hi 

    The issue was not resolved as I mentioned in my previous response 

Suresh 

  

GilbertQ
Super User
Super User

Hi @venkatasuresh_g 

 

Unfortunately, it is not possible to create hierarchies and use them in direct lake mode as an alternative, you can drag in the individual fields which will then automatically create the hierarchy for you.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors