Calculate % change based on slicer selections without date

[bopeh_99]

Hi! I'm trying to create a measure to calculate the % change of value based on my slicer selections (which is not in date format). 

Here's the sample of my data. My slicer will be "Semester" and I would like to calculate the difference between value based on the selected semesters (up to all of them). For example, if i select semester AH2019 and AH2021, it will show -8% decrease. if i select AH2019, AH2020, AH2021, it will show the % change between all 3 semesters (18.57%, -22%). 

Semester	Value	% difference
AH 2019	7000
AH 2020	8300
AH 2021	6400
SS 2019	10200
SS 2020	18202
SS 2021	8100

Please kindly assist. Your help is much much appreciated.

[bopeh_99]

it will be (8100/8300)-1. the latest year will be the newest value 

[FreemanZ]

hi @bopeh_99 

for "if i select AH2019, AH2020, AH2021, it will show the % change between all 3 semesters (18.57%, -22%)",

how are you going to showcase this part?

[bopeh_99]

id like to show them in a visual like this: 

please ignore the values here. they're different from the table i included but its the same concept 

[FreemanZ]

hi @bopeh_99 

what if  AH 2020 and SS 2021 are selected?