Forum Discussion

kongyuancn's avatar
kongyuancn
Helper II
5 years ago
Solved

Filter Applied on Slicer changes while slicer style changes

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?

 

 

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    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

     

2 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    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