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 

 

It was because the 10k in your examples was too low and it was still summing multiple Sellers MFG count together so Increasing that number solved my issue.

 

Thank you very much this is gonna save me so much time 😄

 

Also, Anonymous could you add that changing the 10k number might work for large numbers of indexes to the post I added as the solution? 

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Do you mean that how to add one "Index" column?

Try this:

Index Column = RANKX(IdSellerMFG,IdSellerMFG[Seller],,ASC,Dense)

 

 

Best Regards,

Icey

 

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

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Icey 

     

    No, I was thinking of the line:

    SUM ( 'Table'[ID] ) / 10000