Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
As mentioned hierarchies are not currently supported in DirectLake
As mentioned hierarchies are not currently supported in DirectLake
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
Could you make sure that the Year column default setting is set to None and not to SUM?
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
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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |