Forum Discussion
rpinxt
Solution Sage
Solution SageGetting a rounded Time value on my column chart X-axis
This seems to be rather complicated..... A picture will probably explain best: So my source has a timestamp. The refresh schedule is every half hour but the timestamp it returns is the end...
Muhammad110
Advocate I
Advocate ISince 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")
This expression will round the timestamps down to the nearest half hour. If you want to round to the nearest full hour instead, you can use "01:00:00" instead of "00:30:00".
rpinxtSolution Sage
Solution SageYes I can make a measure like that and the measure works.
However you cannot use this measure as an X-Axis in a chart...