https://community.fabric.microsoft.com/t5/Developer/Chart-X-Axis/m-p/1459492#M26261 <P>In your Calendar table add a calculated column "Same day last year"&nbsp; and then use that as the x axis for the bottom chart.</P> Wed, 28 Oct 2020 01:50:13 GMT lbendlin 2020-10-28T01:50:13Z https://community.fabric.microsoft.com/t5/Developer/Chart-X-Axis/m-p/1450376#M26226 <P>I created a dax for sameperiod last year calculation. I put calculation in one chart and sameperiodlat year in Prev Chart. But i want to change X-Axis Values to show last year as well. Like 2019 instead of 2020. Is there any other way like using visual level filter where i change bottom chart to last year. For example when someone select Year-month 2020-08 on slicer the bottom chart give 2019-08.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 22 Oct 2020 19:41:10 GMT https://community.fabric.microsoft.com/t5/Developer/Chart-X-Axis/m-p/1450376#M26226 Anonymous 2020-10-22T19:41:10Z https://community.fabric.microsoft.com/t5/Developer/Chart-X-Axis/m-p/1459492#M26261 <P>In your Calendar table add a calculated column "Same day last year"&nbsp; and then use that as the x axis for the bottom chart.</P> Wed, 28 Oct 2020 01:50:13 GMT https://community.fabric.microsoft.com/t5/Developer/Chart-X-Axis/m-p/1459492#M26261 lbendlin 2020-10-28T01:50:13Z