cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sdas028 Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Date changes in column graph based on slicer selection

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

6.png

After select week4

7.png

Here is DEMO, please try it.

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

 

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Date changes in column graph based on slicer selection

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

6.png

After select week4

7.png

Here is DEMO, please try it.

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

 

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sdas028 Regular Visitor
Regular Visitor

Re: Date changes in column graph based on slicer selection

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