cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nicholastrausch Frequent Visitor
Frequent Visitor

Custom Start and End Points for Time Data on X-Axis

I have column chart data scaled on a time-valued x-axis where values are summed per 15 minute (Time data type) segment throughout our work shift.  My problem lies in the fact that I have an operations environment where we work across the midnight time break.  Ideally I want to be able to show the 15 minute time-segments beginning at 12:00 PM segment and ending with the 11:45 AM segment.  

 

I have attempted to format the x-axis, but I still only get the date picker despite it being a Time data type value, formatted as HH:mm.  Any ideas how to accomplish this without doing a calculated time shift to trick the visual into doing what I need?

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: Custom Start and End Points for Time Data on X-Axis

Hi @nicholastrausch,

Got it, I change the type, the date display normal as follows.

1.png

If this is not waht you want, could you post your sample data or PBI file for further analysis?

Best Regards,
Angelia

6 REPLIES 6
v-huizhn-msft Super Contributor
Super Contributor

Re: Custom Start and End Points for Time Data on X-Axis

Hi @nicholastrausch,

What's the hierarchy od the x-axis value in the chart, day, hour, or minutes? "where values are summed per 15 minute (Time data type) segment throughout our work shift" means the difference in two adjacent date value are 15 minites?

>>My problem lies in the fact that I have an operations environment where we work across the midnight time break.  I have attempted to format the x-axis, but I still only get the date picker despite it being a Time data type value, formatted as HH:mm.  

What do you mean? Could you please share more details, sample data or snaoshot for further analysis?

From what I know, the x-axis will display all the values in the filed. For instance, if the date column are each day, it return as the following screenshot when I select date column as x-axis level. Ane the y-asix display the corresponding result.

Capture111.PNG

Best Regards,
Angelia

nicholastrausch Frequent Visitor
Frequent Visitor

Re: Custom Start and End Points for Time Data on X-Axis

There is no hierarchy to date before time in a datetime sense.  I have only time values, imagine everything 01/01/1900 hh:mm for times 00:00 through 23:45.  I am creating this rounded time value for each record through a SQL function during the query. This representation works the best for me and I can slice to specific DOW and workareas through slicers or interactions.  

 

What I need is my x-axis to start at 12:00 and end at 11:45 instead of the traditional 00:00 - 23:45.  Any ideas on how to accomplish that?

 

 

v-huizhn-msft Super Contributor
Super Contributor

Re: Custom Start and End Points for Time Data on X-Axis

Hi @nicholastrausch,

The 12:00 display the noonday, and the 11:45 means 11:45 PM, transferring the date type doesn't accomplish it?

1.png

Best Regards,
Angelia

nicholastrausch Frequent Visitor
Frequent Visitor

Re: Custom Start and End Points for Time Data on X-Axis

sorry... I wasn't clear regarding my times.  All times are scaled in 24-hour clock.  I need the x-axis to run from 12:00 (pm) to 11:45 (am).  

v-huizhn-msft Super Contributor
Super Contributor

Re: Custom Start and End Points for Time Data on X-Axis

Hi @nicholastrausch,

Got it, I change the type, the date display normal as follows.

1.png

If this is not waht you want, could you post your sample data or PBI file for further analysis?

Best Regards,
Angelia

DaveyP Frequent Visitor
Frequent Visitor

Re: Custom Start and End Points for Time Data on X-Axis

Hi

 

I am having a similar issue, all my reports need to start at 6am as we operate up till 5am but everything starts from midnight.

 

so currently x axis runs

00:00-01:00-02:00 up to 23:00

 

i need it to start at 06:00-07:00 up to finishing at 05:00

 

the data type is set to time in the right format but the Xaxis options only let me set a start date

 

 

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 53 members 1,013 guests
Please welcome our newest community members: