How to show percentage on chart based on first value in the chart

[storgall]

I'm trying to make a line chart similar to this one:

My data looks like this:

Dates	Product	Price
1.1.2020	Product1	Price of Product1 in Jan 2020
1.2.2020	Product1	Price of Product1 in Feb 2020
...
1.9.2022	Product1	Price of Product1 in Sep 2022
1.1.2020	Product2	Price of Product2 in Jan 2020
1.2.2020	Product2	Price of Product2 in Feb 2020
...
1.1.2020	Product3	Price of Product3 in Jan 2020
1.2.2020	Product3	Price of Product3 in Feb 2020

I'm trying to achieve this by creating a measure that calculates the first selected month's values and then dividing the values by this measure. I'm getting this measure only for the first month (as if I were using KEEPFILTERS, as in this video https://www.youtube.com/watch?v=HxZLkmpY6BA&t=485s at 8:05 - 9:15).

The measure:

FirstValue =

Var FirstDate1 = MINX(ALLSELECTED(Merge1[Dates]),Merge1[Dates])

Var FirstPrice = CALCULATE(SUM(Merge1[Price]), 'Merge1'[Dates] = FirstDate1)

RETURN FirstPrice

My chart:

light blue = Price

dark blue = FirstValue measure (the dot only on the first month)

orange = the percentage (1 or 100% for first, infinity for others)

I want to show only the orange line after it works.

What am I doing wrong?

Thank you for any help!

[v-luwang-msft]

Hi  @storgall ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[lbendlin]

Please provide meaningful sample data.