Forum Discussion

Rambo92's avatar
Rambo92
Helper I
3 years ago
Solved

Display Financial Weeks based on Calendar Week slicer

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 wh...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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