'Measure' vs 'Date' chart that ends at a selected slicer value

[Anonymous]

Hello,

I have a dashboard with a chiclet slicer that allows me to select which week I want all the measures to calculate in - this all works.

Except:

I have a chart with a measure over time - I want this to always show 4 weeks of data, ending at the selected week on the chiclet slicer.

I can turn the interactions off and it's (unsurprsingly) not affected by the chiclet slicer (what I'm currently doing) so I see all the data.

If I turn the interactions on, it only plots the week the chiclet is selected for.

I would have thought that using all(date_table) or removefilters(date_table) would ignore the chiclet interaction and plot the the measure over all dates in the date table, but no, I only see the week selected.

Here is the view when I have the interaction turned off

here is the view when I have the interaction on:

here is the ideal view (created manually using filters)

While there's a chance I used them wrong (so please do challenge if so) - I have tried:

• various iterations of: all() and removefilters() functions
• creating a virtual table with all date_table
• turning interactions off and trying to retrieve 'selectedvalue' from the chiclet slicer to create the date range, but without interactions I can't retrieve the value

Here is my code for the virtual table approach to get it plot all date values ignoring the filters

once so that I can then put manual filters on based on the selected value. Again - this only plots for the week selected on the filter.

Data Plot =
VAR selected =
    SELECTEDVALUE ( date_table[WeekOffset] )
RETURN
    SUMX (
        CALCULATETABLE (
            SUMMARIZE (
                date_table,
                date_table[Date],
                "Measure to Plot", CALCULATE ( [Measure], REMOVEFILTERS ( date_table[WeekOffset] ) )
            ),
            REMOVEFILTERS ( date_table[WeekOffset] ),
            date_table[WeekOffset] > selected - 4
        ),
        [Measure to Plot]
    )

Thanks so much in advance!

[Anonymous]

@amitchandak

Thanks so much for your response

While I think your solution will work for the graph, I think it will cause the other meaures on the dashboard to no longer be affected by the slicer? My problem is that I have other measures that I would like to continue to be filtered by the slicer

Is that right?

[amitchandak]

@Anonymous , if you select a week and you want for that that, then slicer need to on the independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max1 = maxx(allselected(Date1),Date1[Date])

var _max = _max1 - weekday(_max1,2) +7
var _min = _max -27
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