Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help with Custom Sorts

RTOs (Recovery Time Objectives) are sorted in duration order in Excel. Load Excel spreadsheet to BI and RTOs are still in duration order. However, in the charts (visuals) the duration RTO are out of ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you all for your feedback. Another issue occurs  while using the Related fir custom sorting . 

     

    I am using the RELATED DAX query and it works in some instances . Related tables 'Sheet1' and RTOTable. However, after the Related query is executed in the Sheet1 table, some values are blank even though there is an associated value.  All RTO_ID are listed except for "8" and "10". Why is this happening? See both tables below

     

    Sheet1 Table after the RELATED query is executed

    RTOTable

     

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

In Power BI Desktop, the sort feature would be set as values field by default. If there are the same values, depends on the shared-axis based on the initial alphabetical order.

 

For custom sort in Power BI Desktop, you can refer: 

  1. Sort a Column with a Custom Order in Power BI 
  2. Custom Sort Order Trick in Power BI & Power Pivot 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.