Forum Discussion
Getting a rounded Time value on my column chart X-axis
Since you mentioned that this is not possible in your case due to direct query, another option is to use the "Floor" function in your chart's category axis expression. This will allow you to round the timestamps down to the nearest full or half hour directly in the chart.
Here's an example of how you could use the Floor function in your chart expression:
=FLOOR('Your Timestamp Column', "00:30:00")
Yes I can make a measure like that and the measure works.
However you cannot use this measure as an X-Axis in a chart...
You're right, measures can't be used directly as the X-axis in a chart. However, there is a workaround you can use to achieve the desired result.
Instead of using the measure as the X-axis, you can create a calculated column in your data model that rounds the timestamp down to the nearest half hour or full hour. Then, use this calculated column as the X-axis in your chart.
Here's an example of how you could create a calculated column that rounds the timestamp down to the nearest half hour:
Rounded Timestamp =TIME(HOUR('Your Timestamp Column'),FLOOR(MINUTE('Your Timestamp Column') / 30, 1) * 30,0) let me know if this works as this is the only solution I am thinking of right now
True....but in direct query mode you cannot make calculate columns 😉
Ahh just forgot while giving you the solution sorry