Sorting Department based on Total Employees (Highest to Lowest)

[sureshg2498]

Hi All,

We have a requirement to display the department based on the total employees. Below is the sample dataset.

Department	Full Time Employees	Contact Employees
Sales	20	50
Marketing	40	10
Finance	70	30
IT	150	40

Current Report Structure:

We would like to sort this Department based on the Total employees from Highest to lowest.

Expectation sort results from the chart would be.

Could anyone please help me on this requirement ?

Thanks,

Suresh.

@Bibiano_Geraldo @rajendraongole1 @Ritaf1983 @danextian  @lbendlin @Ritaf1983 @bhanu_gautam

@MohamedFowzan1 

[Ashish_Mathur · Accepted solution]

Hi.

Create this measures

Total = Data(Data[Full time employees])+Data(Data[Contract employees])

Drag this measure to the tooltip.  Click on the 3 dots of the visual and you should now be able to sort the bars in descending order of the tooltip measure.

Hope this helps.

[sureshg2498]

Awesome, thank you so much Ashish! That worked perfectly.

[Ashish_Mathur]

You are welcome.

[v-ssriganesh]

Hi @sureshg2498 ,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Bmejia & @Greg_Deckler for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[sureshg2498]

My question has been answered. Thank you so much.

[Bmejia]

Hi,

Create a summarize table of your main table  on  the department only with the total of both contracts and full employees.  Than hightlight the department and sort by Total.

Create a relationship between this new table and your main table

Then replace your department category with the new summarize department category and then sort visual on Department.

[sureshg2498]

Thank you so much.

[Greg_Deckler]

@sureshg2498 Add a column like the following:

Sort By = [Contact Employees] + [Full Time Employees]

Set the Sort By column for Department to this column and then sort your visual by Department.

[sureshg2498]

Thank you for the reply, Greg.

I did as per your instrauctions. However, I see the below error message. Any thoughts.

Sort By = [Total Contractors]+[Total FullTime]