Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |