Forum Discussion

DanielV's avatar
DanielV
Regular Visitor
7 years ago
Solved

Sort table/multi-row card by another column

Hi,   I have a table containing three columns: Subject, Rank and DisplayIndex. I want to display only the Subject and Rank columns, either in a table or a multi-row card, but I need data to be sort...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    DanielV  - You can set the Sort by Column property of a column. Go to the Modelling tab in the ribbon, select a column from the Fields pane on the right, click Sort by Column and select the associated column:

     

    Hope this helps,

    Nathan

     

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi DanielV ,

     

    Based on my test using the sort by column option, that should work. Please select your subject column and make it sorted by displayindex column as the picture below.

     

     

  • DanielV's avatar
    DanielV
    7 years ago

    I've managed to make it work.

    The problem was that the Value summarization was set to Sum by default. Once I set it to "Don't summarize", the sort behaved as expected.

     

     

    Here's a demo pbix (download). It has the Value summarization set to Sum.

     

    Thank you!

DanielV's avatar
DanielV
Regular Visitor
7 years ago

AnonymousThank you for your replay!

 

I have tried exactly what you suggested, with no results, unfortunately.

 

I have seen the sorted months example all over the internet but it doesn't work in my setup. It's true that I am not sorting a string column but a numeric one, and I am not working with a chart visual but with a table or multi-row card visual. Still, I haven't found any indication of limitation(s) of the "Sort by Column" feature that could explain why I can't make this work. So I must be doing something wrong. 

 

Needless to say, any suggestion would be highly appreciated, being in the form of a solution or a workaround.

 

Thank you in advance!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DanielV  - Could you share a pbix? This should work.