Forum Discussion
Trouble visualizing two data sources together.
I've got 2 seemingly straightforward data sources. The first is a list of the hours our HR department said our workers were clocked in. The second is a list of the hours our workers reported working.
I'm trying to keep track of the discrepancies to encourage our workers to report their time more accuately. More accurate reporting gives us better data, etc. Whenever I use either data source separately in power BI they display correctly, as one would expect.
But whenever I try to use both these data sources in a single visualization one or the other data source displays incorrectly. If I understand the large number spike, it appears Power BI is displaying all the hours for one of the sources without regard to who worked them or what day.
Can anyone explain how I could combine both of these data sources into a single visualization to compare how many hours each worker reported working to how many hours HR said each worker was clocked in? I'm not sure what I'm doing incorrectly here.
Anonymous
Method 1:
You could easily merge the two tables based on Date and Worker and create a single table with below columns. And then you could create the visual you want.
Date, Worker, Hr_reported_hrs, Emp_reported_hrs
Method 2:
Create a key column in the tables combining worker and date
Custom = Text.From([Worker])&Text.From([Date]).
Define a relationship between the tables based on custom columns ( hopefully it will be a 1 to 1 relationship) and create the visual you need.
If this helps, mark it as a solution.
Kudos are nice too
1 Reply
Anonymous
Method 1:
You could easily merge the two tables based on Date and Worker and create a single table with below columns. And then you could create the visual you want.
Date, Worker, Hr_reported_hrs, Emp_reported_hrs
Method 2:
Create a key column in the tables combining worker and date
Custom = Text.From([Worker])&Text.From([Date]).
Define a relationship between the tables based on custom columns ( hopefully it will be a 1 to 1 relationship) and create the visual you need.
If this helps, mark it as a solution.
Kudos are nice too