topic Re: How to use custom sort order in table visual? in Desktop

How to use custom sort order in table visual?

Yonas — Wed, 06 May 2020 03:54:50 GMT

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?

Re: How to use custom sort order in table visual?

Greg_Deckler — Wed, 06 May 2020 01:17:47 GMT

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.

Re: How to use custom sort order in table visual?

amitchandak — Wed, 06 May 2020 02:54:12 GMT

Yonas ,Can you share sample data and sample output.

Re: How to use custom sort order in table visual?

Yonas — Wed, 06 May 2020 03:56:08 GMT

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

Re: How to use custom sort order in table visual?

v-xuding-msft — Wed, 06 May 2020 08:46:11 GMT

Hi Yonas ,

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

Re: How to use custom sort order in table visual?

AnLe — Thu, 13 Feb 2025 05:24:09 GMT

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.