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

Icey This definitely sorts the graphs correct. 

 

However, this results in a scrollbar at the bottom, because there are too many sellers to show at once. 

 

I'm working with 1+ million sellers, so having a scrollbar result in the graph being unmanageable, and I can't get the full picture.

Icey's avatar
Icey
Community Support
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 

     

    What is the reasoning behind 

    SUM ( 'Table'[ID] ) / 10000

    And why is the sum divided by  10000?

    It does not work for me.

     

    Using this code: 

    Rank column = 
RANKX (
    'BaseData';
    CALCULATE (
        DISTINCTCOUNT ( 'BaseData'[MFG] )
            + SUM ( BaseData[Index] ) / 10000;
        ALLEXCEPT ( 'BaseData'; 'BaseData'[Seller] )
    );
    ;
    DESC;
    DENSE
)

    • Icey's avatar
      Icey
      Community Support
      6 years ago

      Hi Anonymous ,

       

      For your question, it is used to re-sort the same sorted sellers. For example, Seller 1 and Seller 2 rank the same, both are the 3th. In order not to "sum" the two values on the visual, seller 2 is ranked 3th and seller 1 is ranked 4th.

       

      Then, please let me know if the "Index" column in your table is the ID of "Seller"? If not, please correct it.

       

      It is best to give me some sample data (not real data) and keep it consistent with your real data structure.

       

       

      Best Regards,

      Icey

       

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