topic Re: Dynamically Add Levels to Hierarchy Slicer in DAX Commands and Tips

Dynamically Add Levels to Hierarchy Slicer

abhiram342 — Tue, 20 Feb 2024 20:46:09 GMT

Hi All - We have two tables i.e Pipelines and Activites, Pipeline table includes PipelineId, ParentPipelineId and PipelineName etc and Activites includes activity info related to Pipeline. We want to create Levels Dynamically from Pipelines Table and Use the Levels to display in Hierarchical Slicer. I was able to get levels dynamically by using Power Query Function i.e Dynamically flatten Parent-Child Hierarchies in DAX and PowerBI – (thebiccountant.com) but unable to create slicer dynamically i.e currenlty one of the Pipeline has 4 levels and if we change the pipelineId to different one it might have 7 levels.

Can you please suggest how can we achive this functionality?

Thanks,

Abhiram

Re: Dynamically Add Levels to Hierarchy Slicer

Anonymous — Wed, 21 Feb 2024 08:00:00 GMT

Hi abhiram342

What you mean is that the level of your pipeline changes dynamically, so you want to create a slicer that changes as the level of the pipeline changes, right?

Best Regards,

Jayleny

Re: Dynamically Add Levels to Hierarchy Slicer

abhiram342 — Wed, 21 Feb 2024 18:13:26 GMT

Hi Anonymous - Yes, you are correct, Because of data size we query data for list of Pipelines and Activities for given product ( Direct Query) and the hierarchy will change based on the product.Is there any workaround solution?

Ex: Product A- 4 Levels

Product B - 6 Levels, when there is increase or decrease in level how to handle it dynamcially in hierarichal Slicer?

Thanks,

Abhiram

Re: Dynamically Add Levels to Hierarchy Slicer

ChandanaMB13 — Sun, 31 Mar 2024 09:31:15 GMT

Hi, even I'm having a similar requirement.. It's like an employee manager hierarchy currently the maximum level is 6 and if a new level gets added I want the hierarchy to include that level also and display 6 level in the slicer.Did u find any solution?