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.

sumanth_v's avatar
sumanth_v
Regular Visitor
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.