Getting a rounded Time value on my column chart X-axis

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