Forum Discussion
Two different data sources in one visual
Hi, I've created a line chart which will have starters and leavers, there are two different tables (one for each).
Both tables have the relevant dates, however when I want to break the results down by quarters it is only updating one of the table numbers while the other numbers stay the same throughout the whole quarters. Could anyone help with this please?
Unfortunately, where I work won't allow it. Thank you so much for offering to help though.
I have found a solution:
Starters = CALCULATE(distinctCOUNT(Starters4[Employee Number]))This worked and I've managed to get the table looking how I wanted it.Thanks again!
7 Replies
Chainfire74 do you have a date table that is connected to both?
Check that you used the month from the date table on the X axis and not the month from only one of the tables.I didn't, but I do now thank you. Now I need to sum the amount of times a certain date appears and add it to the graph. Do you know how I would do that please?
I do but I need more info about your scenario 🙂 You can PM to do a zoom or share here your file and I'll take a look
