Forum Discussion

Yonas's avatar
Yonas
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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.

    • Yonas's avatar
      Yonas
      Icon for Microsoft Employee rankMicrosoft Employee

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

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support

        Hi Yonas ,

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