Date slicer changing chart axis

[sdas028]

Hi, I need help figuring out how to change the date axis on a clustered column chart based on the date that the slicer is selected on. For example: I have a clustered column chart that has total cost of each production area by isoweek and I would like it to be able to change based on the week number that the slicer is and then compare it to the week before i.e. if slicer is on week 32 then clustered column chart is week 32 and week 31 - is this possible? Basically I want to be able to compare the week selected with the previous week

[v-frfei-msft · Accepted solution]

Hi @sdas028,

Based on my test, we can create the measure to meet your requirement.

pr1week = CALCULATE(SUM('Table'[am]),FILTER(ALL('Table'),'Table'[weeknum]=SELECTEDVALUE('Table'[weeknum])-1))

Then we can get the result as we excepted.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/t3riwx1tao9gd4v/week.pbix?dl=0

Regards,

Frank

[sdas028]

Hi Frank,

Thanks very much for that. I ended up changing the way my report was laid out so no longer required it for this, however, I will keep this in the back of my mind if I ever need to do it again! 

Thanks,

Sophie

[v-frfei-msft]

Hi @sdas028,

If you feel that makes sense, kindly mark my answer as a solution to cloese the case please.

Regards,

Frank

[sdas028]

 Hi Frank,

As this is wasn't the solution I used I didnt think marking it as the solution was correct. However, I have now done so for your convenience.