Forum Discussion

sdas028's avatar
sdas028
Helper I
8 years ago
Solved

Date slicer changing chart axis

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

Need Help

4 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    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's avatar
      sdas028
      Helper I
      8 years ago

      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's avatar
        v-frfei-msft
        Community Support
        8 years ago

        Hi sdas028,

         

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

         

        Regards,

        Frank