Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Need help on displaying Financial weeks on scorecard or any visual based on the calendar week slicer selected.
Here is the sample data for reference if needed.
1. Basically what i need is if i select the calendar slicer from week 1 to 5, the visual should show from Week 49 2022/2023 to Week 1 2023/2024.
2. And is there any way to filter for financial weeks from 49 to 1. As the slicers cannot be filtered from higher to lower numbers.
Thanks
Solved! Go to Solution.
HI @Rambo92,
Current you can't directly use the fiscal week field as source to filter records across different years.(these week numbers will be reset when date across the years)
I'd like to suggest you add new calculated column to concatenate fiscal year and fiscal week field values and convert them to numeric type.(e.g. fiscal year * 100 + fiscal week number) Then you can use this new field as source of slicer to achieve cross year filter effects based on week numbers.
Regards,
Xiaoxin Sheng
HI @Rambo92,
Current you can't directly use the fiscal week field as source to filter records across different years.(these week numbers will be reset when date across the years)
I'd like to suggest you add new calculated column to concatenate fiscal year and fiscal week field values and convert them to numeric type.(e.g. fiscal year * 100 + fiscal week number) Then you can use this new field as source of slicer to achieve cross year filter effects based on week numbers.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |