topic Re: Nested Dynamic hierarchies in Direct Lake Mode in Developer

Nested Dynamic hierarchies in Direct Lake Mode

priyankabis — Wed, 03 Sep 2025 21:35:58 GMT

I have a semantic model built out of a direct Lake mode in fabric. I have a requirement to allow users to have nested dynamic hierarchies. Eg i have different values for Level1, Level2, Level3. Now when a user selects a value from Level 1 and then one value from Level 2 and Level 3 then the report data should have hierarchies as selected by the user. Same way the user should be able to select any values for any level and the report shoul be updated based on that.

i know that it is acheivable in Direct query mode. But i am unable to see an option in Direct Lake.

Please let me know if it is possible to achieve the same in Direct Lake mode in Power Bi

Re: Nested Dynamic hierarchies in Direct Lake Mode

lbendlin — Sun, 07 Sep 2025 17:26:25 GMT

Did you enable "Personalize Visuals" and train your users on how to use that feature?

Re: Nested Dynamic hierarchies in Direct Lake Mode

v-ssriganesh — Sun, 07 Sep 2025 17:46:56 GMT

Hello priyankabis,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you

Re: Nested Dynamic hierarchies in Direct Lake Mode

priyankabis — Sun, 07 Sep 2025 20:30:54 GMT

Hi All,

We used parameters and it seemed to have solved the issue. Thanks

Re: Nested Dynamic hierarchies in Direct Lake Mode

v-ssriganesh — Mon, 08 Sep 2025 03:54:03 GMT

Hello priyankabis,
Thank you for your efforts and we're glad to hear your issue has been resolved. We appreciate you sharing your insights, as this will help other community members address similar issues more effectively.

Best Regards,
Ganesh Singamshetty.