Showing turnover 2016/2017 - 6 weeks before and 6 weeks after the current date

[Wout]

Hi Forum,

I have a dashboardpage about the weekly sales numbers of 2016 and 2017,  - Clustered column chart.

Is it possible to show only the sales numbers 6 weeks before and 6 weeks after the current date?

Thanks.

[v-yulgu-msft · Accepted solution]

Hi @Wout,

Suppose you add a [WeekNum] column on chart X-axis, please create measures similar to below:

currentWeek = WEEKNUM(TODAY())

flag =
IF (
    [currentWeek] - MAX ( WeeklySales[WeekNum] )
        <= 6
        && [currentWeek] - MAX ( WeeklySales[WeekNum] )
            >= -6,
    1,
    0
)

Select the clustered column chart, add above measure [flag] into Visual Level filter.

Best regards,
Yuliana Gu

[Wout]

Thanks! It works!?

Do you also know what happens when it's week 48+ for example

[v-yulgu-msft]

Hi @Wout,

The week number showed on X-axis will be dynamically changed when week num is over 48. It always shows the sales numbers 6 weeks before and 6 weeks after the current date.

Regards,
Yuliana Gu

[Omega]

Yes,  by creating two columns that will return the weeks before and after your current week. 

Can you please share the PBIX?