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

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