cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gauravcd
Frequent Visitor

Line Chart with Individual Performance vs Average Team Performance

Hi,

 

I've been using Power BI Pro to try and build an employee performance dashboard. I currently have the employee data as; Employee Table(UserID, Name, Supervisor, Manager, Cost Center) and the KPI that I'm measuring, eg. daily sales stored as DailySales Table(Date, UserID, Sales). I've been trying to figure out a way to have a line chart where if a slicer were used to select a particular employee, then the chart will display two lines; one to display the employees sales trend, and the other will display the average sales for their respective supervisor. 

 

The idea is that the employee or their supervisor should be able to compare the employee's performance against the overall team average. 

 

I've been using Power BI Pro for over a month now and have generally been able to find what I've been looking for here pretty easily, but this problem has me stumped! Would appreciate it if someone could point me in the right direction or let me know if I'm missing something.

 

Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
gauravcd
Frequent Visitor

Re: Line Chart with Individual Performance vs Average Team Performance

Nevermind, I've figured it out! I created another measure that ignores the slicer selection and calculates the average. Adding it to the chart works exactly like I was hoping it would.

 

Here's the link to where I found the solution if someone else is looking for a solution to a similar problem:

 

https://community.powerbi.com/t5/Desktop/how-to-ignore-slicer-in-calculate/td-p/453682

View solution in original post

1 REPLY 1
gauravcd
Frequent Visitor

Re: Line Chart with Individual Performance vs Average Team Performance

Nevermind, I've figured it out! I created another measure that ignores the slicer selection and calculates the average. Adding it to the chart works exactly like I was hoping it would.

 

Here's the link to where I found the solution if someone else is looking for a solution to a similar problem:

 

https://community.powerbi.com/t5/Desktop/how-to-ignore-slicer-in-calculate/td-p/453682

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors