Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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*/
Solved! Go to Solution.
@kumar27 I *think* you want Chelsie Eiden's Duration: Chelsie Eiden's Duration - Microsoft Power BI Community
@kumar27 I *think* you want Chelsie Eiden's Duration: Chelsie Eiden's Duration - Microsoft Power BI Community
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |