Matrix Custom Sort

[Anonymous]

Hello,

This thread is related to the thread I posted before:

https://community.powerbi.com/t5/Desktop/Transform-hierarchy-JSON-to-flat-Excel/m-p/696378

The issue there was solved, but here is another one.

I have the following matrix visualisation:

All columns in the matrix are composed of several columns from separate tables. The problem is, that I need to order the first column called Aktivita, but not by the Aktivita column, but by column, the Aktivita column is computed. I will try to explain it.

The underlying structure consists of 3 tables.

I want to order it by caszacatku (datetime) and nazevaktivity (text).

The Aktivita column is added column where is text which was created by concatenation of several columns from the same table.

The matrix is sorted by the text order in the column custom_activita (which is column Aktivita in the matrix). But I need to order it by caszacatku (datetime) and nazevaktivity (text) from the same table.

I added Sorted Rows step at the end of the applied steps.

I added sorting to this column in the Data tab.

But the matrix is still sorted alphabetically by the Aktivita column.

Does exists any way how to solve Matrix by the datetime column in one of the tables?

Thank you

Ondrej

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918