DAX

Hi Sowmiya,

I understand your requirement and Based on the raw data that you have provided, i suggest you go for the below steps,

1. Create a dimension with the distinct values of year from the Raw data. So,

      Table 1 : Your original Raw Data

      Table 2 : Dimension table with the column year (Distinct value)

2. Relate these two tables with the year column

3. Use year column from the dimension table as your report filter 

4. Average of value will be in the vaue field in the visual.

Click on the year filter and apply the properties whether you want to single select or multi select values.

Based on your selection, the visual should display the trend of it.

Hope this helps a lot and find the solution for your problem.

Regards,

Pradeep