Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Line graph with period ending point

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]

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.