Drill Through in Parent Child Hierarchies
Hi all - I have table with parent-child ids along with Levels. One of requirement is table to see Parent information on the same page when User click on ParentId column in table chart i.e Clicking On ParentId should display information about it. I'm not sure If I can achieve it on same page hence I tried with drill through approach by cloning the exisitng page but It's not working. Please suggest if there are any other approaches to achieve the functionality. Also, Is there option to update Slicer based on Selected Column in Table Chart? Example: Data: Clone the Page and Enable Drill Through: Verify Drill through Option on Summary Page: Clicking on Drill Through gives the data for ParentId = '0728b2f0' but I'm looking for ParentId information i.e PipelineId = ParentId(0728b2f0). Please assit 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, AbhiramHelp with DAX Measures on Parent Child tables recursively
Hi Team, I have two tables, Pipelines and Activities. Pipeline Table has ParentPipelineId's, I want to create below measures by travelling recursively at the root level. I have created basic measurse but need help on recursive part. Please help Measues: # of Automate ==> Example: For PipelineType ==> A => We want to travel till root (child) and consider count all the activities, in this case it should Activities For 123 (3) + Activities for 456 (2) + Activities for 789 (2) # of Manual ==> Same Behaviour as Automate by TaskType will be Manual # of Unique Activities => We want to travel till root and consider distinct Activity ID Example: For Pipeline TypA, Activity ID 1 is repeating in both PipelineId 123 and 789, we want to count as 1. Relationship: Pipelines ( PipelineId - 1) <-------- Activities ( PipelineId --*) Thanks, Abhiram
Hierarchy parent-child issue ( using only DAX )
hello everybody , I have these two tables in powerbi, my data arrangement is as showed in table 1 and in table 2 column ALL LEVELS exist , how can I add three columns to retrieve the values of each level in seperated column? I must do that with dax I have tried so many different way but still it does not bring the values in this order! I need more fresh ideas thank you in advance !  
Need help Showing values as % of parent column total.
Can anyone please help in trying to find a way to show, based on Quarter 1 and Quarter 2, rows as a percent of total. in POWER BI Current view in Power BI showin percent of row total.... I need percent of row total but based on parent column... like for Q1 it should be 20% for adjusted and 80% for FTC to malke 100% not like below where its 20% then 40% then 40% to make 100%. IN EXCEL IT IS POSSIBLE by JUST using "VALUE FIELD SETTINGS" THEN SHOWING VALUES AS " % OF PARENT COLUMN TOTAL" but I cant do this in power bi?? Need this above view in power BI! Anyone can help please? THANKS!Remove blank childs in a Gantt chart with parent-child hierarchy
I cannot figure out a way to set up a Gantt chart that shows the full hierarchy (project - lv1, story - lv2, task - lv3), without showing blank childs (or default childs, parent as child). In my hierarchy, some stories (level 2) may not have child tasks, therefore the column "Task - LV3", calculated using PATHITEM, is empty. I am using the Gantt Chart by MAQ Software. I have created a filter measure that, if placed in a matrix with the same dimensions, only shows childs if a parent have some: Remove Blanks = SWITCH(TRUE(),AND(ISINSCOPE(Table[Level2]), ISBLANK(VALUES(Table[Level2]))), BLANK(), AND(ISINSCOPE(Table[Level3]), ISBLANK(VALUES(Table[Level3]))), BLANK(),1) However, I cannot find a way to make it work in the Gantt Chart. If I try to use it as a filter, it will only shows full hierarchies, namely items that have lv1 & lv2 & lv3, therefore losing all the stories (lv2) and projects (lv1) that do not have tasks (lv3). Can someone help? Thanks
Dynamic Running Total in Parent-Child Hierarchy
Hello, I have a list of elements [1 through 7] which are hierarchly ordered as shown in the screenshot below (see diagram). Each element has its own cost (column F). Through a Path Function I was able to trace the Parent-Child Relationship using Power Pivot / Power BI. I would like to know how cna I calculate column G (Dynamic Running Total Costs) in Power DAX, and if there is a way to replicate this in Excel. You may see on column I shows how column G was calculated. Additionally, it is desired that if data is filtered out (i.e., 5 is taken out) it will reflect on the remaining entries (running cost would decrease).  
