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, AbhiramDynamically generate Levels in Parent-Child Hierarchy - Hierarchical Slicer
Hi Team, I have Pipelines table below with Child and Parent PipelineId, We want to generate Hierarchy Slicer based out of it. Currenlty, I was able to generate manually using Path and PathItems with sample data, however, we have ParentPipleineIds in the range from 2 to 16 for some PipelineTypes, I believe generating 16 Columns will degrade the perfome of model . Is there any alternative Solution Or Cloning the Table with relationships/ Redesign? Please Suggest Pipeline Table RowCount is 5 Million rows Also, Regaridng Blank Value For Each Parent, Can we achieve same behaviour by clicking on Parent and Elimintaing Blank Value? ( Highlighted) Thanks, AbhiramHow to filter Parent ID only in child-parent Hierarchy slicer
Hi All, I have table with Pipelines and Activities. However, In Pipelines Table, I have ParentPipeline and When I select ParentName, data should filter only to specific parent and don't filter childs. Also, When I filter specifc Child, it should filter data for specific child and shouldn't filter parent. Can you please help how to achieve it? Should I need to redesign Pipelines Table? Pipelines: Activities: Pipelines ( PipelineID) 1 --> Activites (*)(PipelineId) ( 1 to Many) Issue: When I select ParentName as "Process" Or ParentPipelineID as "B", It should display rows for PipelineID == B but below screenshot display data for child i.e C & D. Please suggest how to display data for ParentPipelineID only i.e PipelineID == B Thanks, Abhiram
How to make dropdown slicer present "multiple selections" if more than one value has been selected?
Hello everyone, In order to solve the problem I had in the 1st screenshot I applied the dax code shown in the 2nd screenshot. The code seems to be working perfectly fine as long as the user has chosen one specific deparment (single selection), the output is shown in screenshot 3. However in the case where a user picks a second deparment (screenshot 4), the measure will continue to show only one of the two or multiple selections. Is there a way to tweak the code (or a completely different code), that could instead show "Multiple selections" (Screenshot 5) when the user has chosen more than one departments? 1st 2nd 3rd 4th 5th Thank you in advance!
