Line graph with period ending point

[Anonymous]

Hey 

I am working on a line graph what shows the %  sale but i want to change the cut off point for the '% sale ') to end at year 2021. The reason why it drops is because there is no data for 2022 (but i need to keep the row data for 2022 for other data

All lines in the graph is calculated from a measure 

Measure 3 (Final - The purple line) 

PercentageSale = ([AddSale] - [AverageSale]) / [AverageSale]

[Anonymous]

Maybe you need to modify your third measure, "PercentageSale".

PercentageSale = IF('Education %'[Year] <= 2021, ([AddSale] - [AverageSale]) / [AverageSale], BLANK())

This will calculate the % Sale only for years less than or equal to 2021 and show it as a blank for the year 2022.