Sort Matrix by AttributeSort column

[jcastr02]

I have a matrix visual and I'd like to be able to sort the columns in a specific order.  I created a conditional column within the data table to create a numerical number based on the "Attribute" Column.  (ie. If it's X, then give me X number, etc.).  I went tables and then sorted the attritbute column by the AttributeSort column.  However, my visual still stays in alphabetical order.  Any ideas?

[v-achippa · Accepted solution]

Hi @jcastr02,

Thank you for reaching out to Microsoft Fabric Community.

Power bi does not apply custom sort order to the fields used in the columns section of a matrix visual. Even if the column is sorted correctly in the data model, the matrix will still show the column headers in alphabetical order by default. So please follow below steps:

• Create a new supporting table with the required Attribute values and a custom sort order column.
  

  AttributeSortTable =

  DATATABLE(

      "Attribute", STRING,

      "SortOrder", INTEGER,

      {

          {"Area Name", 1},

          {"Specialty", 2},

          {"Central Pharmacy", 3},

          {"Midwest Specialty", 4},

          {"New England Spec", 5}

      }

  )

• In this new table, go to the Attribute column and use Sort by Column and choose SortOrder.
• Use this new Attribute column in the Columns section of the matrix visual instead of the original one.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[jcastr02]

I don't have ability to sort by attribute either.

[jcastr02]

@samratpbi apologies for confusion the AttributeSort column was created in Power Query, then I went to Tables and did the Sort by columns but it's still not ordering the information in the sort order I designated.

[samratpbi]

Hi, sorting the table view will not sort your data. In this case, better to create that AttributeSort column using Power Query. Then in the table view, select Attribute column use the feature "Sort by Column" and select AttributeSort column. That will sort your Attribute column in all the visuals wherever being used.

Hope this helps to resolve your problem; if it does, then please mark it as solution and dont forget to give kudos. 

Thanks - Samrat

[jcastr02]

I don't have ability to "sort by" attribute....