Is there a way to position to certain points in a slicer

[Rsteinke]

I have a list of several thousand entries, is there a way to position to a certain starting point in a slicer such as "M" or is there something other that slicers that would work

[v-juanli-msft · Accepted solution]

Hi,Rsteinke

As you said ,what I understand is:

Put a column in a slicer, and filter it based on the first character, then select a value from the slicer to filter the visual.(such as M)

Is my understanding right?

There are some workaround

One is to import Smart Filter from marketplace, you could input values (as a starting point) in the search box on the Smart Filter.

Another is

first,create a calculated column

Column =
LEFT ( 'Table4'[Column1], 1 )

next,put the newly created column and column1 in two slicers

then,edit interaction for the middle slicer as the following picture

finally you will get

Best regards

Maggie