Forum Discussion
How to use custom sort order in table visual?
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?
5 Replies
- Greg_Deckler
Community Champion
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.
- amitchandak
Super User
Yonas ,Can you share sample data and sample output.
- Yonas
Microsoft Employee
amitchandakBecause of privacy I can not share sample data from my case, Can you rather use the above example datasets?
- v-xuding-msft
Community Support