Using the search loop into a slicer

[Anonymous]

Hello,

I am working for a bilingual company, so our employee name are either French or English.  When we make a seach in a table using the search tool of a slicer, how do we deal with name containing an accent.

for example, an anglophone will look for Frederic while a Francophone will look for Frédéric.

In our tables, I believe that the name are written with a correct orthograph i.e. we could have Frederic Remington or Frédéric Chopin.  Both of these persons are well knowed.  However if we make a search into the employee name slicer, someone could type Fre and find Frederic Remington and never Frédéric Chopin.  The opposite will give the same issue.

Is there a way to use a seach tool none caracter sensitive, i.e. to find both names?

Thanks in advance for your help

alepage

[v-yulgu-msft]

Hi @Anonymous ,

As of now, this is not achievable within a slicer.

Best regards,

Yuliana Gu

[Anonymous]

Hello,

I notice from your last message that this option is not available at the moment in Power BI.

However,  as I am importing my data from a SQL server Data base, I have found on the web the script below and I though I could share that info with the community.

Select

                FirstName collate SQL_Latin1_General_CP1253_CI_AI as NonAccentFirstName
,               LastName  collate SQL_Latin1_General_CP1253_CI_AI as NonAccentLastName

from server.databased.tablename

When you select get data from a sql server data base, a window pop-up with the following options:

server:  put your server name

database: put your database name

advanced option: put the above mentioned script and click ok

In your PBIX project add a column ex: CorrectedFullName = NonAccentFirstName & "  " & NonAccentLastName

Then in the slicer, we can use the field CorrectedFullName, rename it for ex: Employee Name

Thereafter, it is possible to make a Employee Name seach using the loop in the slicer and all the available name appears.  It is then possible to conserv either in the table and in the matrix, Employee Name (firstName & " " & LastName) in the original form i.e with accent.

Obviously, I don't know if it is possible to use this approach when the data are imported from an Excel spreadsheet.