Forum Discussion
TableSorter Custom Power BI Visual - Rankings
I'm using the Table Sorter visual to rank entries based on a score. For entries that have the exact same score the tool defaults to ranking based on alphabetical order. Is there a way to change this so that entries with the same score receive the same ranking?
4 Replies
Tsoltvedt , Not sure on table sorter, But we usually use rank measure for rank
examples
Rank Discount % = RANKX(all("Item"[Category]),[Discount %],,DESC,Dense)
Rank Discount % (Brand) = RANKX(all("Item"[Brand]),[Discount %],,DESC,Dense)For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measuresMany thanks for the reply. I have tried RANX but the challenge I'm facing is that I need the rank to be calculated based on the particualar configuration chosen in the slicer. The table contains data across different years/quarters and different categories. What I'm looking to do is get a rank that applies to the specific category and year/quarter selected.
Table Sorter seems to do this, but as I mentioned in the initial post and reply there is a bug that means that the selection defaults away from the Dense ranking mode.
Many thanks for the reply. I have tried RANKX but the challenge I'm facing is that all the entries end up being ranked as 1. The table has four columns: 'Country', 'year-quarter', 'index', and 'score'. I'm trying to rank the countries based on their score for a specific index and year-quarter. I have tried the formula below but all countries end up ranked as 1:
RANKX(FILTER('Global Indices R1','Global Indices R1'[Year-Quarter] = SELECTEDVALUE('Global Indices R1'[Year-Quarter])&& 'Global Indices R1'[Index name] = SELECTEDVALUE('Global Indices R1'[Index name])),CALCULATE(MAX('Global Indices R1'[Score]),ALLEXCEPT('Global Indices R1', 'Global Indices R1'[Country Name])),,DESC)
For some reason, toggling "histograms" off and on under the "Presentation" tab fixes the problem temporarily but the tool reverts back to default ranking when publishing or re-starting Power BI Desktop.
