Show multiple slicer headings above table

[automate2create]

Hi there

I have a table and a slicer that work correctly together.  The slicer values are dates e.g. 2000, 2001, 2002 etc.  If I select multiple dates on the slicer, that table changes accordingly.

I want to display the chosen multiple dates from the slicer above the table but I can't find a way to do this without pushing the table data down.  Is it possible that the slicer values can be displayed horizontally maybe and how?

What are my options for displaying the selected slicer headings above my table?  Thanks

[MikeJohnsonZA · Accepted solution]

Hi

You can use the CONCATENATEX  function for this, it will append all the values, whatever those might be which in your case is the selected years. the formula will look something like this.

Display Selected Years = CONCATENATEX(ALLSELECTED('Dates'[Years]),[Years],",")

I created a little sample and this is what it looks like, I use a card visual to display the list of selected dates from the filter

Hope I understood your problem correctly