Data Model - Want the Slicer to list whatever is selected into a cell

[sabellcyclist876]

I have a complex data model with many data sources all linked together quite well, but some of the arrays need to reference the text of what I'm selecting in the slicer. I know I've done it before, but it's been years. Any ideas how I can copy the text of what's selected on the slicers into an Excel? Thank you!

 

[Alex Blakenburg]

I think this might be what you are after:
Dynamic Chart Title with Slicers - Excel University

Essentially you create a Helper Pivot Table which uses the same slicer and displays the selection criteria summarised as say the columns of the helper pivot table.
If you have O365 you can just use TextJoin on the row, to put all the selected items into a cell. eg =TEXTJOIN(", ",TRUE,23:23)
Your profile indicates you may not have textjoin, Jeff Lenning's article also provides the Concatenate version which is quite a bit longer. eg =SUBSTITUTE(TRIM(CONCATENATE(B23,” “,C23,” “,D23,” “,E23)),” “,”, “)

 

[sabellcyclist876]

I think this might be what you are after:
Dynamic Chart Title with Slicers - Excel University

Essentially you create a Helper Pivot Table which uses the same slicer and displays the selection criteria summarised as say the columns of the helper pivot table.
If you have O365 you can just use TextJoin on the row, to put all the selected items into a cell. eg =TEXTJOIN(", ",TRUE,23:23)
Your profile indicates you may not have textjoin, Jeff Lenning's article also provides the Concatenate version which is quite a bit longer. eg =SUBSTITUTE(TRIM(CONCATENATE(B23,” “,C23,” “,D23,” “,E23)),” “,”, “)

Thanks, that works amazingly! What do I do if I want to be able to have it filter on one specific thing or All? In a normal pivot, it would just say "All" on top, but I'm not sure how to handle it in this case.

 

[Alex Blakenburg]

In a slicer clicking the little filter button normally clears the filter and selects all.
To select one thing is just clicking the one thing in the slicer.