How to show TOP N values based on the Latest value?

[DeepakBaberwal]

I have a line graph with X axis Year&Quarter, in Y axis Attrition % , and in legends 10 regions.

now let say in current year region 3 4 5 is having highest attrition %. i want to show only these three regions line graph.

in my graph it is showing the top 3 region in that particular year and quarter?

[v-juanli-msft · Accepted solution]

Hi @DeepakBaberwal

Create measures

Rank = RANKX(FILTER(ALL(Sheet4),[year]=MAX([year])),[sum],,DESC,Dense)

show top3 2018 = IF(MAX([year])<>2018,1,IF(MAX([year])=2018&&[Rank]<=3,1,0))

Assume [sum] is a measure to show Attrition % of each region in each year.

Then add [show top3 2018] in the Visual Level filter and apply "show item when value is 1"

Best Regards

Maggie