Dynamically Add Levels to Hierarchy Slicer

[abhiram342]

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

[ChandanaMB13]

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? 

[v-jialongy-msft]

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

[abhiram342]

Hi @v-jialongy-msft - 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