cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kaissya Occasional Visitor
Occasional Visitor

12 Month trend from different queries

 

Hi

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?

2 REPLIES 2
Community Support Team
Community Support Team

Re: 12 Month trend from different queries

Hi @kaissya,

 

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.

 

sales for each emp mbm.png

 

If it is convenient, could you share your table structure and your desired output so that we could help furter on it.

 

Best  Regards,

Cherry

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.
Community Support Team
Community Support Team

Re: 12 Month trend from different queries

Hi @kaissya,

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please share some data sample and your desired output so that we could help further on it.

 

Best  Regards,

Cherry

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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 37 members 1,054 guests