Treemap chart and top 10 clients

[iLikeAzureSQL]

Hello friends,

I'm using treemap chart for client sales, but the chart is very busy with over 100 clients, is there anyway to limit the chart for only top10 clients?

Thanks in advance,

iLikeAzureSQL

[khalidwaleed]

@Sean Thanks for this solution, works like a charm.

[Sripriya]

We can directly use Visual level filters 'Top N' for showing Top 10 clients based on their sales

[iLikeAzureSQL · Accepted solution]

I end up using this meausre:

SalesRank = RANKX(all(Clients),sumx(RELATEDTABLE(OrderArchive),[Total Sale]))

[Sean]

@iLikeAzureSQL Create a Ranking Measure. Something like this...

Sales Rank = RANKX ( ALL ( Table[Client] ), CALCULATE ( SUM ( Table[Sales] ) ) )

Then drag this Measure to the Visual Level Filter => select is less than or equal to 10 => Apply Filter

[Achuthanunni]

Thanks Sean. 

[Achuthanunni]

Thanks Sean.