Forum Discussion

viswaaa's avatar
viswaaa
Helper IV
9 months ago
Solved

Nested sorting in Matrix

Hi All,   I have a country column and created a bucket to sho others as separate.so created below dax. Placed country_group and country in rows in matrix   Country_Group = IF( 'Table'[Country]...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    9 months ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    It seems like sorting by sorting by two columns in the matrix visualization shows expected result.

    Please check the below picture and the attached pbix file.

     

     

     

danextian's avatar
danextian
Super User
9 months ago

Hi viswaaa 

 

Create a custom column and use it to sort country group - Sort one column by another column in Power BI 

Country_Group  Sort =
IF ( 'Table'[Country] IN { "Other 1", "Other 2" }, 1, 0 )

 You will also need to create another sort column for country but you need to do it in Power Query as referencing the column being sorted by in the sort column will return  a cyclical error.