CREATE a FUNCTION that allows to extract the exact text the user put into the TEXT SLICER

[JacekJNJ]

CREATE a FUNCTION that allows to extract the exact text the user put into the TEXT SLICER

The SELECTEDVALUE returns the result of a SEARCH function and I would expect the result of an EXACT fuction.

[kleigh]

I tested this with FILTERS. It shows the resulting filter (rows selected by the filter) and not the input text. Especially when slicers are synced, it is important to maintain a display showing HOW the data was filtered. This detail hadn't occurred to me before, but now it's been mentioned it seems essential!