Display 30 minutes past each hour instead of full hours on x axis

[Lobo1908]

Hi, 

I have a report that displays units done per hour. The x axis is showing Time and the hours are displayed in full hours. E.g. 12:00, 13:00, 14:00. I was asked to change it to 30 minutes past each hour as this would match the shift pattern wich is 8:30-16:30.

So basicaly instead of 12:00 I need 12:30, insted 13:00 I need 13:30 Etc. 

Is there an easy way to do it? Is there an option to format the visual in such a way? 

Please support guys 

Kind Regars 

[v-yadongf-msft]

Hi @Lobo1908 ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[Lobo1908]

Hi @v-yadongf-msft ,

My apaologies I did not have time to chech this yet, I'm aimimg to do it by end of the week. 

I will defenetly accept the solution if it works 

Kind Regards 

Lobo

[v-yadongf-msft · Accepted solution]

Hi @Lobo1908 ,

In the current Power BI, you cannot customize the interval of the X-axis or Y-axis. You may vote on these ideas:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17297545-add-the-axis-interval-in... 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15293673-axis-with-configurable-u... 

The alternative is to create a new column. Please try:

New_time = 'Table'[Time]+TIME(0,30,0)

Don't forget to change the data type to text type:

Then create a new measure

Sort = 
var select_time = SELECTEDVALUE('Table'[New_time])
return
SWITCH(select_time,"8:30:00 AM",1,"9:30:00 AM",2,"10:30:00 AM",3,
                   "11:30:00 AM",4,"12:30:00 PM",5,"1:30:00 PM",6,
                   "2:30:00 PM",7,"3:30:00 PM",8,"4:30:00 PM",9,
                   "5:30:00 PM",10)

Put the new measure into tooltips as below image shown, sort by the new measure juest created and you will get the result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.