Foprmat numbers a a duration
In systems such as angular it is possible to take a duration, eg number of seconds, and format it in a human readable way eg "approx 1 year". This would allow sorting by the numeric base data type and not having to perform custom format statements with leading "0"s to facilitate a text sort
Massive functionality gap at the moment.
Gabriel Grünberg commented
This is a bit of a showstopper right now.
Prefered solution from my perspective is to base this on seconds.
ie. you input a whole number or decimal second value and get Power BI gives you options how you want to present it.
Dream scenario would be to have checkboxes for what you want to have as part of the value:
years, months, days, hours, min, seconds, milliseconds.
or just a couple of preconfigured settings:
and so on.