Forum Discussion
Fixed x-axis
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?
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]))
1 Reply
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]))