The conditional title is not working when setting the slicer to types other than List and Dropdown

[David_Liao]

I'm implementing a multilingual report. I need to change the titles of the slicers and charts based on the selection of a language sclier.

The back-end table is like this:

The expected effect is like this, using a language slicer to control the row that is to be filtered:

Then I combined the back-end table to the slicer whose title I wanna control:

However, when the slicer is set to between type, the conditional formatting simply not working, unless I change it

to List or Dropdown type:

Is this a bug or just the design? What can I do if I want to use the 'between' type but also need to control the content of its title?

Thanks!

[lbendlin]

Shouldn't you be using the built-in localization functions?

[David_Liao]

Hi lbendlin, 

I didn't know there were built-in localization functions to implement multilingual.

I've seen quite a lot of tricky methods to do this. Currently I'm using a single language table.

For this issue, I've used a textbox to show the title instead of using the built-in conditional formatting title of slicers.