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

     

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Hi Anonymous,

 

Your DAX is creating a calculated table. However caclulated tables are only refreshed when the model is loaded with data. Eg they are never dynamic. The reason it therefore shows blank is there is no SELECTEDVALUE so that line returns blank.

 

You could create a dynamic table in a variable within a measure but I suspect there might be easier ways of achieving what you are trying. Are you able to share a demo pbix file?

 

Thanks


Ben

  • 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