Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

data relationships

I have two different tabs on excel. One has employees and amount of hours worked per employee. Another has phases of a project and the amount of hours in each phase as well as the total number of hou...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I just did that but my visualizations are still not interacting 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can you please post your revised data model and also share what are trying in the visuals . Please share the PBIX file if you need more help.

 

Thanks
Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    As per the Emp table,  Sam spent 66 hrs and Patrick spent 192 hrs for meeting, but the master table shows only 12 hrs spent for meeting. This is wrong, The Emp table needs the breakup on the hrs spent for each phase. 

     

    For example, you may have multiple rows for Sam, like this:

     

    Sam -6 hrs- meeting

    Sam- 15 hrs -Design

    Sam -45 hrs - Implement etc.

     

    Thanks

    Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Ok, I did that. But it still is not interacting.  I was hoping to click on a column in the Cost by Phase graph and have the visuals with the employee information adjust based on that