Get selected items in a slicer in Excel 2016

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

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


Tags: excel, slicer


2007-2015 VidasSoft Systems Inc.