Creating a rolling 6 week date range for use in graphs

mur2za instead of putting the measures you used into the graph, use them in either the page level filter or the graph visual filter. Then for your axis put in a date column. The measures should filter the axis to what you want.

The other option is to create a custom column as follows:

Last 42 days = IF(AND(DateKey[Date]>=[Today]-42,DateKey[Date]<=[Today]),1,0)

[Today] is a measure : Today = DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))

Enter the last 42 days column in the page level or visual level filter and then select 1. Enter a date column in the axis of the graph. This will maintain a rolling 42 day axis.

Thanks,

Giles

mur2za adding a Page Level Filter will of course as the name suggests affect the remaining contents of your Page

Without Filter

With Page Level Filter