Forum Discussion
Set the selected time range in slicer
Super UserAnonymous so you will have this extra table will filter your date table. Solution should work to meet your expectations.
parry2k I am playing with the example posted in the article. A chart and a slicer based on the date column in the filtered table are added to the report. When the period selection is changed, I can see the chart axis is changed with it correctly, but the slicer always shows the whole time range. My assumption is since this slicer is a filter for the date, it overrides the filter the Time Intelligence table applies to the data source. How can I change the selected range in it based on the selected period?
The chart axis is changed to two months, the slicer is not:
I was expecting something like this:
daxCommunity Support
Hi Anonymous ,
According to your description, it seems that you want to use one slicer to control another date slicer's range, right? I am not sure whether this could be achieved. As I know, we need to use column in slicer, but slicer can't affect calculated column. So I think this might not be achieved.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the information. We will just use one slicer if that's the case.