Have Time On Y axis onto Power BI that can be used as a baseline for measures / calculations

[kumar27]

Have you been into a situation, where you're looking for different ways to display time on the y axis, however it's not working out ..
Currently Power BI does not support this.

I was into a similar situation and hence was not able to find a direct visual or a way to do it. For my workaround which I did using DAX to get a similar 24 hour time frame over my Y axis, and then plotted other metrics as per my baseline.
Below is the code for the same. Lmk how you guys have handled it in past or the workarounds being used..

Time =
(
HOUR(MAX([Finish Time EST]))*10000
+MINUTE(MAX('cube Stats'[Finish Time EST]))/60*100*100
/*This gets the minutes to a percent(/60), then percent to number(*100), then number to proper place(*100)*/
+SECOND(MAX('cube Stats'[Finish Time EST]))/60*100
/*This gets the seconds to a percent(/60), then percent to number(*100)*/
)/10000 /*gets value to 0-24*/

[Greg_Deckler · Accepted solution]

@kumar27 I *think* you want Chelsie Eiden's Duration: Chelsie Eiden's Duration - Microsoft Power BI Community