Forum Discussion

sdas028's avatar
sdas028
Icon for Helper I rankHelper I
8 years ago
Solved

Date changes in column graph based on slicer selection

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 wa...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
8 years ago

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%20selection.pbix?dl=0

 

 

 

Best Regards,

Lin

sdas028's avatar
sdas028
Icon for Helper I rankHelper I
8 years ago

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