Dynamic dashboard dropdown that includes headers from main data table

%3CLINGO-SUB%20id%3D%22lingo-sub-3494437%22%20slang%3D%22en-US%22%3EDynamic%20dashboard%20dropdown%20that%20includes%20headers%20from%20main%20data%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3494437%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20link%20my%20column%20headers%20from%20master%20data%20table%20to%20a%20drop%20down%20menu%20that%20will%20dynamically%20change%20the%20data%20in%20my%20main%20dashboard%20to%20reflect%20the%20data%20under%20the%20various%20categories%20of%20services%20we%20offer%20that%20are%20included%20in%20the%20header%20as%20categorical%3F%20I%20tried%20a%20pivot%20table%20with%20slicers%20but%20I%20cannnot%20make%20a%20slicer%20from%20table%20headers%20without%20the%20data%20showing%20up%20as%20the%20selection%20criteria.%20I%20just%20three%20main%20headers%20that%20manipulale%20the%20chart.%26nbsp%3B%20I%20dont't%20no%20VBA%20nor%20Macros.%20Sorry.%20I'm%20learning.%20Thank%20you.%20Hope%20someone%20can%20point%20me%20in%20the%20right%20direction.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EBest%2C%3CBR%20%2F%3EScott%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3494437%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3494923%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20dashboard%20dropdown%20that%20includes%20headers%20from%20main%20data%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3494923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314645%22%20target%3D%22_blank%22%3E%40Scott_Appleton_HSDPT%3C%2FA%3E%26nbsp%3Bis%20this%20different%20than%20the%20other%20post%20that%20I%20was%20working%20with%20you%20on%3F%20I'll%20post%20the%20updated%20file%20that%20doesn't%20require%20LAMBDA%20here%20also...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

How do I link my column headers from master data table to a drop down menu that will dynamically change the data in my main dashboard to reflect the data under the various categories of services we offer that are included in the header as categorical? I tried a pivot table with slicers but I cannnot make a slicer from table headers without the data showing up as the selection criteria. I just three main headers that manipulale the chart.  I dont't no VBA nor Macros. Sorry. I'm learning. Thank you. Hope someone can point me in the right direction. 


Best,
Scott

1 Reply

@Scott_Appleton_HSDPT is this different than the other post that I was working with you on? I'll post the updated file that doesn't require LAMBDA here also...