Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Tsoltvedt
Regular Visitor

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 4
Tsoltvedt
Regular Visitor

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.

amitchandak
Super User
Super User

@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-measures

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
)

 

Many 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. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.