Power BI and R

[Anonymous]

I have Power BI data as follows:

flights attribute Value

Emirates	ETA	9/09/2021 12:30
Emirates	Arr Time	9/09/2021 14:50:00 PM
Turkish Airlines	ETA	9/09/2021 17:30:00 PM
Turkish Airlines	Arr Time	9/09/2021 18:50:00 PM
Cathay Pacific	ETA	9/09/2021 19:30:00 PM
Cathay Pacific	Arr Time	9/09/2021 14:50:00 PM
Qatar Airways	ETA	9/09/2021 20:30:00 PM
Qatar Airways	Arr Time	9/09/2021 20:50:00 PM
Lefthansa	ETA	9/09/2021 12:30:00 PM
Lefthansa	Arr Time	9/09/2021 13:50:00 PM

I need to create a chart in Power BI, flights in x axis, time in y axis and attribute as the fill.

After researching a couple of days, to pot time in y axis the only solution I could find was R.

I changed the data type of column Value to Time and also converted time to integer using the formula below:

Column = HOUR('Query4 (2)'[Value])*3600+minute('Query4 (2)'[Value])*60 + SECOND('Query4 (2)'[Value])

My graph in R now shows time as integer, how do I display time instead of integer number.

The R code I've used is below:

library(ggplot2)

library(hms)

library(plotly)

c1_graph <- ggplot(dataset, aes(workflow_code,Column, fill= Attribute, label=Value))+

#scale_y_time(limits = c(as.POSIXct(as_hms("09:00:00")), as.POSIXct(as_hms("13:30:00"))))+

geom_col(width=0.4, position=position_dodge(width=0.5))+

coord_flip()

c1_graph

[Anonymous]

Hi,

I need to create a interval on y-axis for the chart which I've produced in Power BI using R.

AS you can see in the above image, in y-axis it displays all the time intervals. Instead I only want it to list every hour so that my chart will look neater.

Help is greatly appreciated.

Regards,

aRa

[amitchandak]

@Anonymous , for that, create a column in your table having only hour and use that in R visual

Hour = time(hour(column]),0,0)

[Anonymous]

Thanks @amitchandak  The writeup helped.

[amitchandak · Accepted solution]

@Anonymous , refer if this can help

https://www.groundflooranalytics.com.au/resources/power-bi/custom-axis-formats-using-r-visuals