Get last weeks of Y-Axis

[#1]

Hello community!

Is there a way to show only the last values on an Y axis?

My problem:

I have some weeks in my data, let's say from week 30 to 45.

On my chart, I want to show only 5 weeks but only the 5 last weeks of the current selection, and those weeks ordered chronologically with first (of the 5 last weeks of the current selection) on the left and last on the right.

Is it possible?

I tired to set up a set analysis to get the number of weeks to display but when user selects week 30, 35, 40, 41 and 45, I am stick...

Any idea?

Thank you in advance for any usefull comment.

Hub

[IAMDV]

Hi Hub,

Have you tried using Sort by expression in your chart? I mean if you have numeric value in the Week Field or you can create a psuedo numeric value for Week Field. Then you can sort by this field to always work irrespective of selections.

Cheers - DV

[#3]

In fact I hqve the Year-Week ordered by Text A-Z and then on the presentation tab, I set 5 as max visible values and tick the "Reversed" button : done.

I really do not understand why this button is not in the "Axis" tab...