Sorting Stacks in Stacked Bar Chart

[tsbrian]

Hi

I have a stacked bar chart with 2 dimensions (YearMonth, Job Type) and 1 measure (Jobs Count). As there are many job types and I want to limit the job type by Top 5 and also i need to sort the stacks(Job Type) in descending order. I am not able to achieve this. Need help on this please.

Thanks

Vijay

[sidhiq91 · Accepted solution]

@tsbrian  Please use the below expression to the top 5

if(Aggr(rank(sum(jobcount)),Month,Jobtype)<=5,Jobtype)

And to sort the job type:

If this resolves the issue, please like and accept it as a solution.