Need latest four week to show in column chart automatically not select it from filter

[hb0135]

Hello,
I have all weeks data in column chart but in that only latest four weeks to be shown automatically not selecting the filter/slicer below is the shown image.
In this i want see wk 28,27,26,25 and if week changes then the current week and last 3 weels data should be seen autmatically

Regards
Atharva

[mdaatifraza5556]

Hi @hb0135 

Can you please try this to get your last week result.

Add visual level filter.

Drag Date column to the visual level filter and then in filter type set Relative date and as shown in the snapshot.

If this answers your questions, kindly accept it as a solution and give kudos.

[danextian]

Hi @hb0135 

Is that automatic based on the latest week or based on slicer selection? Also, what if the last four weeks are from two different years?

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

WINDOW function (DAX) - DAX | Microsoft Learn

Sales latest 4 weeks: = 
VAR _t =
    WINDOW (
        1,
        ABS,
        4,
        ABS,
        ALL ( 'calendar'[Year Week], 'calendar'[Start of Week] ),
        ORDERBY ( 'calendar'[Start of Week], DESC )
    )
RETURN
    CALCULATE ( SUM ( sales[sales] ), KEEPFILTERS ( _t ) )