Display Financial Weeks based on Calendar Week slicer

[Rambo92]

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

[Anonymous · Accepted 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