Top 9 in different area charts

[kinkate18nic]

Hello,

I want to select top 9 rows based on highest to lowest sales value and show the product in 9 different area charts, like 1st chart will have highest product's monthly sales, 2nd chart will have 2nd highest product's monthly sales and so on.

I want to give different colors to different chart, so not using small multiples, since small multiples, there is not option to color each chart differently.

Any suggestions?

Thanks

[amitchandak · Accepted solution]

@kinkate18nic , Create measures like these you need to have more measures for each rank.

use the Top and check that not blank in visual

rank = Rankx(allseleced(Table[Product]), [sales],,desc,dense)

Top product = maxx(filter(values(Table[Product]), [rank] =1), [Product])