Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line Chart sort x-axis by y-axis

Hi    I have a table consiting of Sellers, MFGs and Partnumbers.  It looks like so: _____________________________ Id1 | Seller1  | MFG1 | Part1 Id2 | Seller2  | MFG2 | Part1 Id3 | Seller3  | MF...
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    How about add a Rank column in your table, like so:

    Rank column =
RANKX (
    'Table',
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[MFG] )
            + SUM ( 'Table'[ID] ) / 10000,
        ALLEXCEPT ( 'Table', 'Table'[Seller] )
    ),
    ,
    DESC,
    DENSE
)

     

    Then, create the bar visual with "Rank column".

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Icey 

 

No, I was thinking of the line:

SUM ( 'Table'[ID] ) / 10000

 

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Thank you for your reminding, indeed, when encountering large indexs, this may be problematic. You can adjust according to your actual data.

 

 

Best Regards,

Icey