For a multi page report I'd like to put all synchronised slicers on the first page and then show the selection result on cards in all aother pages.
I followed this tutorial by Curbal:
https://www.youtube.com/watch?v=_k_Qxb6pyCc
This works for selecting numbers. But....
I have text in the selectable fields.
So how do I return multiple selected strings from a slicer?
I hope it's just a small thing that I'm missing.
[edit]
Here's two images:
First page with slicers
Second page with visuals and cards based on the selection on page one.
Kind regards,
Erik Crins
There is a function that aggregates the values in a table - CONCATENATEX
https://learn.microsoft.com/en-us/dax/concatenatex-function-dax
If you want to show all the values selected in a slicer on a card you can use it like this:
Text = CONCATENATEX(ALLSELECTED(Slicer[Field]), [Field], ", ")