Forum Discussion
Linking multiple tables for one visual
I'm trying to find the best way to do this but my limited understanding and knowledge of PowerBI is just frying my brain. I have 2 main tables: Table 1 - Timesheet data: Employee entries with ea...
Step 0: I use your data below. (Date: yyyy/mm/dd)
Step 1: I add a 'WBS Element' column to the 'Remedy customer list' table.
WBS Element = [Cat match]&" - "&[Order type]
Step 2: I make a 'Calendar' table.
Step 3: I make a 'WBS-List' table.
WBS-List = SUMMARIZE('Timesheet data','Timesheet data'[WBS Element])
Step 4: I add some relationships below.
Step 5: I make some tables and some matrixs.
Somehow I forgot to put my ask in the main post..
How can I create a visual which will show the total hours logged against each customer and the total new orders placed for each customer, both on the Y Axis and the WBS Element text on the X Axis.