How to set the bounds on a time only axis?

[ross27]

I have a clustered bar chart with  a field of data type time on the X-axis.  What I'd like to do is explicitly set the bounds of the axis from 00:00:00 to 23:23:59 so that the scale doesn't change as the user applies further filters.  Is there a way to do this?  The format options seem to require me to include a full datetime as my start and end parameters.

[v-jiascu-msft]

@ross27

Hi,

If you have a column which is just time (not datetime), you can try it. Though it isn't perfect, it works. Have a look at picture for details.

Best Regards!

Dale

[ross27 · Accepted solution]

Thanks for the reply Dale, but the issue I had with that approach is that I get no data in my chart - presumably because the date part is missing from my time-only field.

In the end I was able to achieve what I wanted not by setting the bounds, but by selecting "Show items with no data" on the field I was charting.

[v-jiascu-msft]

@ross27

My pleasure. I am so glad you have solved you problem.

Best Regards!

Dale