Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I use a relative date-filter in my report, which shows the last 10 weeks from now:
But I also have two other slicers based on years and weeks, which filter some other visuals:
The relative date slicer always counts x weeks from now (last week, 51), not depending on what week is chosen on the other slicers:
Does anyone of you know, how I can combine these slicers (e.g. If I choose week 46, the relative slicer goes 10 weeks back from week 46)?
I've tried to solve it via the visual interaction, but unfortunately it didn't work.
Thanks a lot!
Solved! Go to Solution.
@PBIUser12 , You can not. You have to build using date slicer and custom slicer and custom measure
refer example
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Hi @PBIUser12 ,
Has @amitchandak 's solution solved your problem? If yes, please kindly accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ kalyj
@PBIUser12 , You can not. You have to build using date slicer and custom slicer and custom measure
refer example
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Ok, thank you! 🙂
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |