How to filter Parent ID only in child-parent Hierarchy slicer

[abhiram342]

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

[Rupak_bi]

Hi, You are getting the right result based on the relationship you have created. Just look at your pipeline table, Pipeline ID "C "& "D"only mapped against parent ID B and so the same you are getting.  To get Child data for "B" make slicer on pipe line ID column from pipeline table.