Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Arunsaik
Regular Visitor

undefined

Hi all,

 

How can I dispaly last 52 financial weeks in the visualisation when I have three years of financial year and financial week of data and this dashboard will be updated every financial week.

 

When I use top N filter on Financial week, Current financial year we are missing Financial week 1 and 2 but I want to display last 52 weeks from current financial week.

Thanks in advance.

1 ACCEPTED SOLUTION
Arunsaik
Regular Visitor

I found a solution by creating a new column by concatenating the financial year and financial week. With this column selected to the top N 52 values, it solved the issue. Thanks all.

View solution in original post

1 REPLY 1
Arunsaik
Regular Visitor

I found a solution by creating a new column by concatenating the financial year and financial week. With this column selected to the top N 52 values, it solved the issue. Thanks all.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.