Forum Discussion

carlosDash's avatar
carlosDash
Advocate V
8 years ago

Sort by Column does not change sorting order

Hi,   My goal:   List ONLY the names of the TOP 5 sales people in my organization by using the "Sort by column" feature.    EDIT: The columns "FirstName" & "LineTotal" come from separate tables...
Need Help
carlosDash's avatar
carlosDash
Advocate V
8 years ago

Thanks for your reply Sean!

 

1. How do I do this? I have currently chosen the tile, then I've chosen the "LineTotal" from the right side pane and then clicked on the "Sort by Column" button. It shows "LineTotal" shown as the sorting method, but it still sorts incorrectly.

 

2. I can't use this method since I don't actually want to list the sales values. I just added them to the screenshot to prove that the sorting does not work.

 

Another screenshot:

 

 

 

 

Sean's avatar
Sean
Community Champion
8 years ago

How are the two tables related?

 

1) Create a FirstName Rank Column in the Table containing FirstName

This Column should Rank DESC based on the Line Total from the other Table

2) Sort FirstName by this new Column

3) then Filter TOPN - show Bottom 5 - by value - sum of FirstName Rank

 

Hope this helps! :smileyhappy:

  • carlosDash's avatar
    carlosDash
    Advocate V
    8 years ago

    They're related through my data model. The relation works properly in my report, there should not be an issue.

     

    I think what's happening here is that I'm essentially using the sorting correctly, but PBI doesn't understand how to sort the sums correctly. I haven't tried creating a proper TOP N style column for this I did create a simple manual type of rank where I gave values to the employees from "1 to 5". Sorting that worked as expected.