Forum Discussion

NCPowerBI's avatar
NCPowerBI
Helper I
3 years ago
Solved

Syncing X Axis

Hi all,   I'm trying to sync the months on the X axis so the data isn't separated like this. I want both lines to be parallel so you can compare the two month over month. I have month placed on and...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

NCPowerBI , seem like you have filter last 11 or 12 month on visual that is why you are not able to compare

 

Ot you can have meausre for last year like

 

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

 

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

 

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

  • NCPowerBI's avatar
    NCPowerBI
    Helper I
    3 years ago

    This worked, thank you!