Stacked bar chart week number axis question

[Anonymous]

I have a stacked bar chart using the week number as an axis point.  This works just fine but I want to limit the view to a four week rolling view with the current week on the right and three weeks ago on the left.  How can I get this done?

Thanks for the information

[HashamNiaz · Accepted solution]

Hi @Anonymous !

You can create a measure to calculate Last 4 weeks Sales / KPI.

You can then place this measure on your chart and it will show weekly Sales based on Last 4 weeks.

Regards,

Hasham