How to use custom sort order in table visual?

[Yonas]

Sorry, the question was not clear, I want to sort using the property colum, I have two datasets the first is in the main visual table (main page) and I have many columns, but for this case I just got two. I have two pages for the Main page(Table1) and the drillthrough page. 

Table1

Name    Service     product

Jhon      Buy           4 

Alice      Sell           3

I have unpivoted using service and property column and It look like this

Name    Attribute     Values

Jhon      Service         Buy

Jhon      Product        4

Alice      Service         Sell

Alice      Product        3

What I wanted to do is, when i drillthrough on table1 (Table Visual on main page) using Jhon(Table1), I wanted to see something like this with the sort order by attribute just like below

Name    Attribute     Values

Jhon      Service       Buy

Jhon      Product      4

But I see something like this

Name    Attribute      Values

Jhon      Product         4

Jhon      Service          Buy

the Attribute column Order is random when i drillthrough

Any ideas?

[amitchandak]

@Yonas ,Can you share sample data and sample output.

[Yonas]

@amitchandakBecause of privacy I can not share sample data from my case, Can you rather use the above example datasets?

[v-xuding-msft · Accepted solution]

Hi @Yonas ,

Maybe you could try adding an index column and then sorting by it.

[AnLe]

Hi! I am now trying to solve the same problem, but adding an index column has not helped, as the column is not included in the vizual, it s not sorted by it.

[Greg_Deckler]

Wait, what are you sorting on in the visual?

Honestly, it's an interesting question of whether/how sort is preserved as you drill through.