Forum Discussion

AdamMetz23's avatar
AdamMetz23
Advocate I
2 years ago
Solved

Sorting column chart X axis by two level hierarchies

Dear Power BI Community.   Can you please help me with  the following issue if you have seen similar situation before? Situation snippet: Here are values on a column chart. the measure values (3...
Need Help
  • lkalawski's avatar
    lkalawski
    2 years ago

    AdamMetz23 ,

    It's sometimes hard to find the problem without knowing the data model, but try using this code for a second sort:

    RANK (
    SKIP,
    ALLSELECTED ( 'Table' ),
    ORDERBY ( 'Table'[Value], DESC, 'Table'[Group], ASC ),
    LAST,
    PARTITIONBY ( 'Table'[Group] )
)

    This code does ranking based on values ​​and partitions by groups.

lkalawski's avatar
lkalawski
Resident Rockstar
2 years ago

AdamMetz23 ,

It's sometimes hard to find the problem without knowing the data model, but try using this code for a second sort:

RANK (
    SKIP,
    ALLSELECTED ( 'Table' ),
    ORDERBY ( 'Table'[Value], DESC, 'Table'[Group], ASC ),
    LAST,
    PARTITIONBY ( 'Table'[Group] )
)

This code does ranking based on values ​​and partitions by groups.

AdamMetz23's avatar
AdamMetz23
Advocate I
2 years ago

lkalawski , Thank you.

 

I have modified your original DAX a bit my adding ALLSELECTED to the _valueranking variable and it works perfectly now.

 

 

Thank you for your help once again and have a great weekend 🙂