Forum Discussion
Team comparison using slicers both with same data charts
Hello to all
Hoepfully I'm asking in the right category. Just want to ask for a simple way wherein I compare different teams using the same data set with a slicer.
I have these sample set data. I want to compare the average of all Productivity, core, and total % by using two different slicers for the team. but can also navigate the date by Year and month
| TEAM | Date | Productivity% | Core % | Total % |
| Team A | 4/1/2020 | 89.00% | 98.55% | 93.20% |
| Team A | 4/2/2020 | 90.00% | 90.20% | 96.50% |
| Team A | 4/3/2020 | 92.30% | 99.30% | 94.40% |
| Team A | 4/4/2020 | 100.00% | 98.00% | 98.30% |
| Team A | 4/5/2020 | 95.40% | 99.00% | 99.20% |
| Team A | 4/6/2020 | 90.55% | 98.70% | 100.00% |
| Team B | 4/1/2020 | 93.20% | 89.00% | 98.55% |
| Team B | 4/2/2020 | 96.50% | 90.00% | 90.20% |
| Team B | 4/3/2020 | 94.40% | 92.30% | 99.30% |
| Team B | 4/4/2020 | 98.30% | 100.00% | 98.00% |
| Team B | 4/5/2020 | 99.20% | 95.40% | 99.00% |
| Team B | 4/6/2020 | 100.00% | 90.55% | 98.70% |
Currently I have a working data charts for one team only (or the combinations of different teams using the multiple options) that looks like this
SLICERS:
Data graphs
but in another page, i want an interactive team comparison (team A data vs Team B data) that would look like this. Year, Month and quarter can be for both data. but I want to limit each side of data to each respective teams chosen in the Team Slicer (Team A vs Team B)
Hi Burubear
I had a very similar requirement to this in order to compare whole life costs between two vehicles from a single list.
I solved it by selecting each slicer then using View > Edit Interactions. This allowed me to select which side of the comparison each slicer filtered.
My output (not my prettiest work!):
All the slicers on the left only filter visuals on the left and vice versa.
Pete
3 Replies
There two way. You select 2 teams in the slicer and in one formula you choose min team and another one you choose the second team
Team 1 =
var _min = minx(Team,Team[Team])
return
calculate([Measure], Team[Team]=_min)
Team 2 =
var _max = minx(Team,Team[Team])
return
calculate([Measure], Team[Team]=_max)Another method is having to slicer, there you have use userelation and cross filter to make it work.
This is done for dates. you need to do for teams
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi Burubear
I had a very similar requirement to this in order to compare whole life costs between two vehicles from a single list.
I solved it by selecting each slicer then using View > Edit Interactions. This allowed me to select which side of the comparison each slicer filtered.
My output (not my prettiest work!):
All the slicers on the left only filter visuals on the left and vice versa.
Pete
Thank you!
This really helps out a lot. Encoutered this solution with other post but most of the just refers to one slicer to 2 charts or 2 slicers to one chart. Was confused that if I click on "none" for the graph that it wont filter anymore but it's all clear now. Thanks a lot
