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

the Employee Table should have the break up of hrs spent for the phase/ per employee. You should include a new column Phase in the Emp table. Then you can make the relationship between these 2 tables basaed on the "Phase" column .

 

Thanks
Raj

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