Forum Discussion

sdas028's avatar
sdas028
Helper 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 want the column graph to display week 32 and week 31 costs. Please help

Need Help

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community 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
      Helper 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