Sort by Data Source Order in Matrix Visual

[obera]

Hi everyone, I understand how to change the sort in a Visual to sort by values/alphabetical, and to change which column to sort the data by, but I have a different situation. I am pulling from a table that has text information in a specific order in the column. This order is not alphabetical. When I create a Matrix from this table, it automatically sorts and shows the data alphabetically. How do I show the data in the same order that it is in the table?

Example:

Source Table

Column 1 ||  Column 2

--------------------------

B Text      ||   1.85

A Text      ||   2.01

C Text      ||   1.36

Matrix Visual (this is how it displays by default)

Rows = Column 1

Values = Column 2

Column 1 ||  Column 2

--------------------------

A Text      ||   2.01

B Text      ||   1.85

C Text      ||   1.36

At a minimum I need "B Text" to be on top, but preferrably I want Column 1 in my Matrix Visual to display in the same order as it is in the source table. They are unique values.

Thanks for your time.

[Nathaniel_C · Accepted solution]

Hi @obera ,

Add an index column to your table, then sort by that index column.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel