Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Table - Not Affected by Source Table fields except one Field

Hi All, I am new to Power BI. Please assist, urgent help needed.  As you can see in below Gantt chart, I am trying to display resource allocation with respect to Skills (present in vertical redacte...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I am able to solve the issue. I have created a disconnected table and used treatas function to make the visual relationship between tables. I have used following expression in measure filed in disconnected table

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

@bcdobbs  Thanks for responding. Sure I will share the pbix file but I am not getting option to attach the  .pbix file. Could you share your email, I can sent you...

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

I created two new tables:

 

Skills = 
    DISTINCT ( 'Skill Gaps'[Skills] )

SkillsTable2 = 
SUMMARIZE(
    'Skill Gaps',
    'Skill Gaps'[Skills],
    'Skill Gaps'[Resource],
    'Skill Gaps'[Start_Date],
    'Skill Gaps'[End_Date]
)

 

Swapped both your visuals to use Skills from the new Skills dimension table.

 

In the second visual switched the other fields to come from SkillsTable2

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks  bcdobbs for looking into it but the problem still persists. Sorry in case I was not clear before about the problem.

    In my data, for skill Java, there are two resources assigned (James & William) but both has different timelines to learn Java.

    But in below screenshot, I selected James’s bar for Java Skill from Ist Gantt Chart, but 2nd Gantt Chart shows only James. I want to see both James & William in 2nd Gantt chart irrespective of where I click on Java bar.

     

    My expectation is to see the 2nd Gantt chart output as below