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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    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

  • sdas028's avatar
    sdas028
    Helper I
    8 years ago

     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.