Forum Discussion

sdas028's avatar
sdas028
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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
Icon for Helper I rankHelper 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
    Icon for Community Support rankCommunity 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
      Icon for Helper I rankHelper 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.