cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Matte7 Frequent Visitor
Frequent Visitor

Filter last x weeks

Hi all! I was wondering how to filter my x-axis in order to have only the last 10 weeks. 

 

As you can see below by default it shows all the 52 weeks of the year, and it's very ugly to watch.

I tryed to use an advance filter, but it only permitt to enter number and not formulas.

Cattura.PNG

Sorry if it is a dumb question and thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
sailkitty Regular Visitor
Regular Visitor

Re: Filter last x weeks

HI- if you make a date slicer and select "Relative" as your slice type you select however many weeks, days, etc you want and it is dynamice to the data 

 

relative.pngPowerBI Relative.png

View solution in original post

5 REPLIES 5
Thejeswar Senior Member
Senior Member

Re: Filter last x weeks

Hi @Matte7,

You can restrict the last 10 weeks using TOP N Filter as shown in the below image

last 10 weeks.PNG

 

 

The Top visual shows the data for all 52 weeks, while the bottom visual shows only the last 10 weeks

Matte7 Frequent Visitor
Frequent Visitor

Re: Filter last x weeks

Hi @Thejeswar, thanks for the reply,

this is not exactly what I looking for, because I meant last 10 weeks starting from now, for example:

today we are in week 34, I want to show data from week 24 to week 34.

Thejeswar Senior Member
Senior Member

Re: Filter last x weeks

Hi,

If you are having only 34 weeks data with you, filtering TOP 10 is still going to give last 10 weeks which is from 25 to 34 weeks.

 

 

sailkitty Regular Visitor
Regular Visitor

Re: Filter last x weeks

HI- if you make a date slicer and select "Relative" as your slice type you select however many weeks, days, etc you want and it is dynamice to the data 

 

relative.pngPowerBI Relative.png

View solution in original post

Matte7 Frequent Visitor
Frequent Visitor

Re: Filter last x weeks

@Thejeswar no, I have all the 52 weeks in my calendar, I think the solution provided by @sailkitty is more correct.

Thank you both!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,920)