As posted previously, a band chart is a basic line chart enhanced with a shaded area displaying the upper and lower boundaries of a group of data or the range between the maximum and minimum of all members of the group. Many thanks to my friend Robert Mundigl for the inspiration of this replica. His blog-post on this underrated chart type is a must read.
Now, let's enable contextual analysis by adding a second Teams slicer. The first slicer allows multiple team selections to calculate the min/max/average salaries of those teams. The second slicer lets the user pick one team (e.g., Red Sox) to compare its salaries with the combined stats of teams selected in the first slicer (e.g., Yankees, Cubs, White Sox).
You can download the pbix file below. Feel free to poke it.
eyJrIjoiMzE3YTlkYmMtNzcyNi00ZDJmLTgwNjItY2ZkZmNkMWZjZDY4IiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9
