Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Thought I would show a simple solution for adding time format to Y-Axis of charts as I couldn't find a solution for this -
starting with a simple dataset below - (time is in time format HH:MM:SS)
Step 1 -
Add a new column turning time into a decimal in hours e.g. 01:30:00 = 1.5 hours
using formula -
Step 5 -
Add HH:MM:SS measure into Y-Axis of chart and Date column into X-Axis.
Step 6 -
Change Y-Axis display units to None as in the below -
The result should be something similar to the below -
Also works with bar charts. Hope this helps anyone struggling with getting time on the Y-Axis.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |