I have weekly NFL schedule with three slicers to pick from

%3CLINGO-SUB%20id%3D%22lingo-sub-2695848%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20weekly%20NFL%20schedule%20with%20three%20slicers%20to%20pick%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2695848%22%20slang%3D%22en-US%22%3EI%20still%20need%20help%20with%20this%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2696304%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20weekly%20NFL%20schedule%20with%20three%20slicers%20to%20pick%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2696304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322399%22%20target%3D%22_blank%22%3E%40sf49ers%3C%2FA%3E%26nbsp%3BDid%20away%20with%20all%20of%20your%20colorful%20tables%20and%20restructured%20the%20data%20a%20bit.%20Then%20with%20the%20help%20of%20PowerQuery%20and%20PowerPivot%20I%20could%20create%20something%20that%20come%20fairly%20close%20to%20your%20requirement.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2696898%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20weekly%20NFL%20schedule%20with%20three%20slicers%20to%20pick%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2696898%22%20slang%3D%22en-US%22%3EHow%20you%20made%20it%20to%20works%20can%20tell%20me%20in%20detail%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697549%22%20slang%3D%22en-US%22%3ERe%3A%20I%20have%20weekly%20NFL%20schedule%20with%20three%20slicers%20to%20pick%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697549%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F322399%22%20target%3D%22_blank%22%3E%40sf49ers%3C%2FA%3E%26nbsp%3BIf%20you%20are%20on%20Excel%202016%20or%20later%2C%20PowerQuery%20(a.k.a.%20Get%20and%20Transform%20Data)%20is%20integrated%20in%20Excel.%20For%20the%202010%20and%202013%20versions%20it's%20an%20add-in.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20goes%20too%20far%20to%20explain%20in%20detail%20how%20it%20all%20works.%20There%20are%20many%20resources%20on%20line%20to%20get%20you%20started.%20For%20instance%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20team%20can%20be%20both%20in%20the%20Away%20and%20Home%20column%2C%20so%20you%20can't%20slice%20a%20table%20for%20a%20team%20on%20both%20columns%20at%20the%20same%20time.%20At%20least%2C%20I%20can't.%20You%20need%20to%20%22flatten%22%20the%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20PowerQuery%20you%20can%20do%20this%20very%20easily%20with%20the%20Unpivot%20function.%20In%20my%20original%20file%2C%20I%20finished%20it%20off%20in%20PQ%20as%20well%2C%20but%20you%20can%20do%20it%20all%20within%20regular%20Excel%2C%20if%20you%20don't%20have%20to%20deal%20with%20too%20much%20data.%20It%20involved%20some%20copy%2Fpaste%20actions%20and%20a%20few%20extra%20formulae.%20Have%20added%20a%20sheet%20(Data2)%20to%20the%20workbook%20to%20demonstrate%20it%20(see%20attached).%3C%2FP%3E%3CP%3EFlattening%20the%20data%20leads%20to%20creating%20two%20rows%20for%20each%20match.%20One%20for%20the%20Away%20team%20and%20one%20for%20the%20Home%20team.%20Both%20rows%20have%20the%20same%20match%20details%20(Date%2C%20Time%20and%20%22Match%20Info%22%2C%20i.e.%20the%20text%20with%20%22Away%20team%26nbsp%3B%40%26nbsp%3BHome%20team%22.%3C%2FP%3E%3CP%3ENow%20you%20can%20create%20a%20pivot%20table%20and%20add%20slicers%20for%20both%20Team%20and%20WeekNumber.%20See%20sheet%20PT2%20in%20the%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2558244%22%20slang%3D%22en-US%22%3EI%20have%20weekly%20NFL%20schedule%20with%20three%20slicers%20to%20pick%20from%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2558244%22%20slang%3D%22en-US%22%3E%20%20%20%20%26nbsp%3B%3CP%3E%26nbsp%3B%3C%2FP%3E%20%20%26nbsp%3B%20%26nbsp%3B%3CP%3EI%20have%203%20slicer%20I%20need%20help%20to%20control%20the%20table%20that%20is%20on%20same%20worksheet.%20I%20got%20one%20of%20SLICER%201-18%20I%20got%20slicer%20working.%20I%20need%20help%20with%20AFC%20teams%20%26amp%3B%20NFC%20teams%20name%20to%20bring%20the%20schedule%20up%20for%20one%20team%20that%20you%20pick%20from%20either%20AFC%20or%20NFC%20team%20will%20show%20all%2018%20week%20in%20schedule%20area%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20picture%20is%20what%20I%20want%20look%20when%20you%20press%20team%20from%20AFC%20or%20NFC%20team%20should%20bring%20schedule%20for%20that%20team%20you%20press.%3C%2FP%3E%3CP%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epleases%20tell%20me%20in%20detail%20how%20got%20to%20work.%20I%20want%20know%20how%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20You%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2558244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

 

I have 3 slicer I need help to control the table that is on same worksheet. I got one of SLICER 1-18 I got slicer working. I need help with AFC teams & NFC teams name to bring the schedule up for one team that you pick from either AFC or NFC team will show all 18 week in schedule area

 

 

the picture is what I want look when you press team from AFC or NFC team should bring schedule for that team you press.

.

 

 

pleases tell me in detail how got to work. I want know how

 

 

Thanks You

 

 

4 Replies
I still need help with this

@sf49ers Did away with all of your colorful tables and restructured the data a bit. Then with the help of PowerQuery and PowerPivot I could create something that come fairly close to your requirement. See attached.

How you made it to works can tell me in detail.

 

How do I get Power Query?

@sf49ers If you are on Excel 2016 or later, PowerQuery (a.k.a. Get and Transform Data) is integrated in Excel. For the 2010 and 2013 versions it's an add-in.

 

It goes too far to explain in detail how it all works. There are many resources on line to get you started. For instance: 

https://exceloffthegrid.com/power-query-introduction/ 

 

A team can be both in the Away and Home column, so you can't slice a table for a team on both columns at the same time. At least, I can't. You need to "flatten" the table.

 

In PowerQuery you can do this very easily with the Unpivot function. In my original file, I finished it off in PQ as well, but you can do it all within regular Excel, if you don't have to deal with too much data. It involved some copy/paste actions and a few extra formulae. Have added a sheet (Data2) to the workbook to demonstrate it (see attached).

Flattening the data leads to creating two rows for each match. One for the Away team and one for the Home team. Both rows have the same match details (Date, Time and "Match Info", i.e. the text with "Away team @ Home team".

Now you can create a pivot table and add slicers for both Team and WeekNumber. See sheet PT2 in the attached workbook.