One of my favourite ways to show a value over time is to display it on a column chart alongside the value from the same period a year before. It allows the users to both see the trend over time and be able to immediately compare to the same period the previous year, without scrolling left and right too much.
To do that in Power BI, I’m Assuming you have a Date dimension called ‘Dim Date’, with a date column called ‘date’. Here’s how the ‘Revenue Same Period Previous Year’ measure should be built:
Revenue Same Time Previous Year = CALCULATE(SUM(‘Fact Sales'[Revenue]), SAMEPERIODLASTYEAR(‘Dim Date'[Date]),All(‘Dim Date’) )
Hopefully that’s simple enough to just copy&paste, and change column names. Let me know if you have any questions in the comments below.