Forum Discussion

MacN's avatar
MacN
New Member
2 years ago
Solved

Custom sorting stopped working

Hi All,  I'm having difficulties setting up custom sorting in the new dashboard, which is quite bizarre as a solution that has worked before now does not. I'm attaching .pbix file where I try to ...
Need Help
  • sumanth_v's avatar
    sumanth_v
    2 years ago

    You can create a new table with Enter Data option from Home ribbon, Enter your Days overdue grouping values in one column and enter valeus 1,2,3... for second column and name it as index and sort the table based on index column.

    In your visual, add the days overdue filed from this new table and remove the old one. Sort your visual based on the days overdue column and it will be sorted in the way you want.

     

    Let me know if you need more assistance.

MacN's avatar
MacN
New Member
2 years ago

Hi,  
Thank you a lot for a quick reply.  
Your suggestion has helped. It looks like I missed the step where I should replace 'Days Overdue Grouping' from the main table with values coming from the related table.  
I'm pleasantly surprised that this also works for the dashboard I'm working on, where dimensions for the charts are coming from Fields Parameters. I just replaced references in the parameter from the main table to the index tables. 

Just out of curiosity; do you know why the second solution isn't working?