Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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 t...
"DAX"
"Dynamic Slicer"
"Need Help"
Hierarchical slicer
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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