Home

Slicer selection to trigger cell contents

%3CLINGO-SUB%20id%3D%22lingo-sub-442886%22%20slang%3D%22en-US%22%3ESlicer%20selection%20to%20trigger%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-442886%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20with%20a%20dashboard%20which%20has%20quite%20a%20bit%20of%20slicers%20outside%20the%20print%20area.%20The%20print%20area%20is%20structured%20to%20fit%20on%20an%20A4%20sheet%20of%20paper%20and%20at%20the%20top%2C%20I%20have%20a%20cell%20where%20I%20manually%20type%20the%20period%20I%20am%20showing%20the%20data%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20for%20a%20monthly%20period%20slicer%20(or%20any%20slicer%20for%20that%20matter)%20to%20trigger%20cell%20contents%3F%20Say%20I%20select%203%20months%20in%20my%20slicer%2C%2001.2018%2C%2002.2018%20and%2003.2018%2C%20could%20this%20selection%20generate%20the%20result%20%22Jan-Mar%202018%22%20in%20a%20cell%20of%20my%20choice%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-442886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-443554%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20selection%20to%20trigger%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443554%22%20slang%3D%22en-US%22%3ESee%3A%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2FArticles%2Fslicers05.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjkp-ads.com%2FArticles%2Fslicers05.asp%3C%2FA%3E%3C%2FLINGO-BODY%3E
dzhogov
Occasional Contributor

Hello all, 

 

I am working with a dashboard which has quite a bit of slicers outside the print area. The print area is structured to fit on an A4 sheet of paper and at the top, I have a cell where I manually type the period I am showing the data for.

 

Is it possible for a monthly period slicer (or any slicer for that matter) to trigger cell contents? Say I select 3 months in my slicer, 01.2018, 02.2018 and 03.2018, could this selection generate the result "Jan-Mar 2018" in a cell of my choice?

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies