Get selected items in a slicer in Excel 2016
User Rating: 1 / 5
My most popular post so far has been "How to get selected items in a slicer without VBA" - Link - and after reading Chris Web's post about the new Excel 2016 ConcatenateX function in DAX - link - I thought that this function could be used to calculate the selected items in a slicer as well. And it turned out the function is the perfect solution to do this - and very easy to implement
Read more...