Include 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

[PijushRoy]

Hi @abhiram342 

Can you please look into the solution pbix file
https://community.fabric.microsoft.com/t5/Desktop/Display-columns-in-Matrix-visual-based-on-selectio...

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[abhiram342]

Hi @PijushRoy  - Thank you for the file, I looked into it but i's not working for my Scenario. In Hierarichal Slicer, I want to filter rows for Top Level column only.

Thanks,

Abhiram