Display weekly chart on a page filtered by a single day

[aroucadaniel]

Hello,

We have a report where the user selects a single day in the filter to view the charts.

However, in one of the charts, we want to show the evolution of a table column in the last 7 days.

Example:
If user filters by 10/20/2022, the line chart will display the days: (1) 10/20/2022, (2) 10/19/2022, (3) 10/18/2022, (4) 10/17/2022, (5) 10/16/2022, (6) 10/15/2022, (7) 10/14/2022.

Note: We cannot change the filter to relative date or interval, since the other graphs only show the values ​​of the single selected day.

[amitchandak · Accepted solution]

@aroucadaniel , if you select  1 day and want to display more than that on rows /axis the filter/slcier should be on an independent table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -7
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI