Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |