Filters removed from slicer when type changed to "Between"

[Anonymous]

Hello,

I'm using a default slicer where I've put on filters.

The moment I change it's type from List to Between, the filters are removed and the slicer doesn't work anymore as expected.

Any alternative? Bug fix?

Thanks 

[v-qiuyu-msft]

Hi @Anonymous, 

Does the issue happen in Power BI desktop or service? 

Would you please share some screenshots so we can understand the issue clearly? Please do mask sensitive information before uploading. 

Best Regards,
Qiuyun Yu 

[Anonymous]

desktop

[Anonymous]

desktop

I have a table D_DATE with column Date

A slicer is used to choose a begin and an end date

I have a table D_LANGUAGE with column CODE_LANGUAGE, with two records:

EN
FR

A slicer is used to choose the language, using the column CODE_LANGUAGE

I have a measure:

Slicer_Title =

var __language__ = SELECTEDVALUE(D_LANGUAGE[CODE_LANGUAGE])

return

switch(__language__;"FR";

"Choisissez vos dates";

"Choose your dates")

This measure is used as title for the date slicer end for a card.

Choosing a language in the language slicer affects the card, but doesn't affect the date slicer eventough the date slicer title has fx conditional formating refering to the measure Slicer_Title

R.W.

[Anonymous]

[v-qiuyu-msft]

Hi @Anonymous, 

I have reported this issue internally: CRI 121034610. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Anonymous,

I got information below:

This is by design. When you convert to a "Between" slicer, the visual interactions between the Code_Language slicer and the Between slicer are set to "Do not filter", since generally you do not want such filtering on between slicers. You can regain the desired behavior by changing the Visual Interaction for Code_Language on the Between slicer to "Filter"

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft 

Thanks,

This works

R.W.