Calculate the Billability per employee and want to filter view TOP 5 and Bottom 5 in chart

[AnshulKamboj]

I want to calculate the Billability per employee in a chart view. To make it possible I have define a column [Billability] and assign the type it to Number.

I Make a simple slice in which I have I make a custom expression i.e. [Billability]>=0.

For Calculating Billability per I make a virtual column in my table and create a expression i.e.

SUM(SELECT(RMG[Billabilty], [Employee Name]=[_THISROW].[Employee Name]))

If I create a chart view Billability Matrix then data is showing correctly.

Now for TOP 5 and Bottom 5 Filter condition

I create 2 action button in in which I have created expressions

For Top 5:- LINKTOFILTEREDVIEW("Billability Matrix", IN([ID], TOP(ORDERBY(BillabilitySlice[ID], [Billability Per Employee], True),5)))

For Bottom 5:-LINKTOFILTEREDVIEW("Billability Matrix", IN([ID], TOP(ORDERBY(BillabilitySlice[ID], [Billability Per Employee], FALSE),5)))

Now If I click Top 5 Button it is only showing the top 2 employees not the rest three

Please correct me what I'm doing wrong.

Please Help @Suvrutt_Gurjar, @TeeSee1 

[TeeSee1]

I don't see anything wrong. If your Bottom expression works, the Top should also work.

What type of chart are you using?

Does it work in a table view?

[AnshulKamboj]

Thank You Sir for your response, Problem is resolved

[TeeSee1]

If you share what caused your issue, it might benefit others.