Top N customers by year in one color and that N customers data in other years

[Gangasaniravi]

 If a customer is top customer in a particular financial period (say FY20) but its not the top ones in FY19 , we need to display  value of it in FY19

if they select top 6 in parameter need to display top 6 is in one color and other values in different color

 Output

 Please help me to get this. I am able to get top 2 customers each year but not able to get other years data for same customer

regards,

ravi

[Gangasaniravi]

Any pointers much appreciate 

[Gangasaniravi]

And Top should be based on user selection in parameter 

[Nankaina]

Hi Ravi,

It seems a similar problem was asked about here, so credit ought to go to @VahidDM for this answer.

Modifying the solution for your data, we add a column:

Rank by Year = 
RANKX (
    FILTER ( ALL ( 'ExampleTable' ), [year] = EARLIER ( 'ExampleTable'[year]) ),
    [sale],
    ,
    DESC,
    DENSE
)

Then, since you're only interested in the Top 2, we can define another column:

Color = if(ExampleTable[Rank by Year]<=2, "Green", "Yellow")

From here, the Matrix element will do the rest of the work. I've set it up as follows:

And the result is as you requested (if not my prettiest work):