Fixed x-axis

[Anonymous]

Hi

I have the following visual:

The x-axis are hours. I made a group from the date field with 1 hour as range. This is the visual after filtering data to only 1 day.

My problem is that when I chose more than 1 day on a filter, the x-axis is changed to dates, like here:

How can I set the x-axis static as 1 hour range for 24 hours - indepentendly of the filtered date range? 

[amitchandak · Accepted solution]

@Anonymous , this is the default date-time behavior of power bi trend.

Please create an only time column and check

Time = [datetime].time

or

Time = time(hour( [datetime]),minute( [datetime]),second( [datetime]))