Report Portal

Get selected items in a slicer in Excel 2016

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...

Tags: excel, slicer

 

2007-2015 VidasSoft Systems Inc.