Top 9 in different area charts

kinkate18nic — Fri, 21 Oct 2022 12:46:24 GMT

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

Re: Top 9 in different area charts

amitchandak — Fri, 21 Oct 2022 15:06:34 GMT

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])

topic Top 9 in different area charts in DAX Commands and Tips

Top 9 in different area charts

Re: Top 9 in different area charts