I am new at power bi and I am having trouble to make a year trend graph. I have twelve queries (from a JSON online database), one for each month. Each query contains 10 employees and their sales along the month. I want a trend line showing how much each employee sold during the year (month by month).
I tried to connect the twelve queries to a new table containing the names of the employees but returned a trend line showing how much each one sold in that month (each line showing a diferente month). When I connect to a calendar table, shows the total (sum of every employee for that month). Can anyone help me with that?
If I understand your scenario correctly that you have 12 tables which contains 10 employees and their sales for each month and now you want to calculate the how much each employee sold during the year?
Do you want to get a chart like below.
If it is convenient, could you share your table structure and your desired output so that we could help furter on it.
Community Support Team _ Cherry Gao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.