Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |