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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous Duration
You will need to convert those to seconds, add them and essentially convert them back more or less. Look at the links below, they should get you what you need.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Greg for your quick response. Seems like a LOT of work for something that can be done in a few seconds, using Excel (2010) via a custom sort. The data I am using is large and though your method would yield the desired results, this method is not practical.

I’m disappointed to learn the archaic way that Power BI does customize sorts. Again, thank you for your feedback which is greatly appreciated!