How to report year wise data if we have multiple years in line chart?

[rajendraongole1]

Hi Experts,

suppose i have 5 years data i have reported as trend wise. if i select on particular spike (High) . how can i report only the data for particular year?

suppose i have taken here line chart. one of the year reporting huge high i want to see the data for only particular year out of many back dated years?

Please suggest.

Regards,

Rajendra

[v-frfei-msft]

Hi @rajendraongole1 ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

[rajendraongole1]

Hi

Pleases find the attached snapshot.

[v-frfei-msft · Accepted solution]

Hi @rajendraongole1 ,

One sample for your reference. Here we can create two measures to work on it.

sum1 = SUM('Table'[value])

maxxsum = 
var maxxsum = MAXX(ALL('Table'[YearMonth]),[sum1])
return
IF([sum1]=maxxsum,"max",BLANK())

[rajendraongole1]

Will check this solution and update you.

Regards,

Rajendra

[v-frfei-msft]

Hi @rajendraongole1 ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.