I want to compare the overall performance of the entire company VS the performance of a certain team VS the performance of a certain individual over time on a line chart, making the team and the individual's line appear when selected.

I want the chart to start ONLY with the overall performance of the entire company's line, let's say in blue.

Selecting a particular team (Filter or parameter. So it was selected as "All teams" to start with) will make its line appear (in addition to the company's line)

Selecting a particular individual (Filter or parameter. So it was selected as "All individuals" to start with) will make the individual's line appear AND the individual's team's line. (in addition to the company's line).

So, there are 3 lines. 1 will always appear: the company's line.

A cool effect would be to have the entire company's line that is originally blue, become grey once you select either a team or an individual. If a team has been selected then its line is blue (So the company's line becomes grey). When an individual is selected its line is blue which turns the team's line grey too (The company's line too), maybe in a darker grey than the overall company's line to give like a hierarchy effect.

I have attached a workbook where I used the Superstore data to illustrate my task but failed.

I used Category as the "Overall company", Sub-Category as the "Teams" and "Manufacturer" as the "Individual".

Feel free to use any other dimension to build this.

I went down the dual axis way but not sure that is correct since I want 3 lines to show.

Thank you for any help,

Nick