Date changes in column graph based on slicer selection

[sdas028]

Hi, I also need help with a clustered column graph. I want to be able to compare the week that is being selected by the slicer with the previous week so for example if the slicer is week 32 then I want the column graph to display week 32 and week 31 costs. Please help

[v-lili6-msft · Accepted solution]

Hi@ sdas028

After my research, You can try to follow my steps like below:

Step 1:

Add a measure that contains last week costs

Last week = 
VAR currWeek =
    MAX ( StoreSales[Week id] )
RETURN
    CALCULATE (
        SUM(StoreSales[costs]),
        FILTER (
            ALL(  StoreSales ),
            StoreSales[Week id]
                IN GENERATESERIES ( MAX ( currWeek - 1, 1 ), currWeek-1, 1 )

Step 2:

Add filed costs and measure Last week into Value of column chart and week into Axis

Result:

For example

After select week4

Here is DEMO, please try it.

https://www.dropbox.com/s/p9tpqpxqnf792tf/Date%20changes%20in%20column%20graph%20based%20on%20slicer...

Best Regards,

Lin

[sdas028]

Hi Lin, 

Thanks for that, I figured out how to do it by adding in "This Week" and "Last Week" to the week dimension I had and then applying a filter for those labels and then a slicre for them also.

Thanks,

Sophie