Forum Discussion
Dynamically Add Levels to Hierarchy Slicer
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
3 Replies
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
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
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?
