Filter Applied on Slicer changes while slicer style changes

[kongyuancn]

Hello All,

I meet a strange problem.

I have a small table:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtU31jcyMDJUMDC0AiMFR18lHSVDpVidaCUzfVOopJEVGCFLmusbwrQaW4ERRNYIXdbECowgssZKsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [DateTime = _t, Data = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"DateTime", type datetime}})
in
#"Changed Type"

In PowerBi, I created a slicer in page 1:

I set sync slicers between page 1 and 2:

Then in page 2, I created another slicer:

When I create the filter button, it shows as following:

It looks good.

But when I change the style of this slicer from "list" to "between"

You can find the applied filter disappeares. (the end date changed from 6/5 to 7/13)

Can anyone help to explain why?

[kongyuancn]

@v-deddai1-msft Great anwer! Thank you very much!

[v-deddai1-msft · Accepted solution]

Hi @kongyuancn ,

Based on my test, If we change the date to between the interaction will be disabled. The solution for your issue is to  sync the slicer from page1 to page2 and also make it visible in page2.

Then eidt the interaction in page2:

Then go to page1 make the slicer invisible on page2:

Then the sync slicer works well on the between date slicer.

Please refer to the pbix file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai