The bug in the slicer using Calculation Group to switch between dates

Hi den_shumilin,

Based on my investigation, this issue seems to be caused by your Date Column Slicer.

When you tick Order Date, the slicer value from your Date slicer will be used to filter Order Date column in your Table visual. But if you tick Deliver Date, the slicer value from Date slicer will filter Delivery Date column in your Table visual.

And it’s weird that if I remove the Sales Amount measure from the Table visual, then no matter what you choose in Date Column slicer, they only filter Order Date column in the table. The Fake Measure set on Order Number slicer seems not have influence on the filter result.

I’ll continue to investigate and report it if it’s a bug. Thanks for your understanding!

Best Regards,

Community Support Team _ Caiyun