Multiple years - Start at the same point on x axis
We have some data on certain products and these products have a year of account associated with them, which is the year the product was offered. We can receive values relating to these products during the year and also after the year of account is finished but not prior to the year starting.
We have a requirement to show the development of different years of account on a line graph, with the lines starting at the same point on the x axis for all the years selected.
We have put together an example pbix file with dummy data to show how far we have got:
As you can see with the first graph, if we use the standard Date table we get lines starting at the first period of each year. We have tried creating some “Rolling Accounting Period” columns which we have used for similar requirements in our SSAS Cubes.
The graph on the right is close to what we need however, we do not want the lines to continue past the latest period we have data for.
We have tried a few different variations of the idea put forward in this video but had no luck: