I created a report to show Rolling 12 months CY, PY using SAMEPERIODLASTYEAR DAX as shown for example;
- NewIntake = SUM(‘Customer Service Center Metrics’[New])
- Previous = CALCULATE(‘Customer Service Center Metrics’[NewIntake],SAMEPERIODLASTYEAR(‘Date2’[Date]))
I am using Relative date in the filter section to limit it to show values in the last 12 month which gives me my 12 month each time a new month is uploaded. This works fine but I am not able to make the X-Axis show Short-Month (Jan, Feb etc.).
I would appreciate help in figuring out what am doing wrong and any suggestion to what solution will work for me.
I have attached Document With Screenshots.
Show short Month Name on clustered chart when Relative date is used for CY PY.docx (452.6 KB)