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!

[kleigh]

I've been looking at this again recently. A user request has come up where a text filter would be appropriate, but since the column being filtered is a list of long titles, generating filter text from the selected values seems impossible - it would not fit in a reasonable space. The user is likely to enter keywords rather than full titles, which would fit. But... there's no way to get the user input! I also have a second use case: A page with a year slicer, but one table ignores the slicer and shows all years. It would be useful for the table to speak to the slicer and retrieve the selected year. This could then highlight the selected year in the table, which would make the intended task on this page easier to perform.