Show measure HH:MM:SS in y axis

[kadapavel]

Hello

there was similar topic discussed, but I have not find answer for my case...

I have a column "Available" which is duration of equipment operation, that I have in decimal points

I created a measure which converts the duration to HH:MM:SS

Now I need to have a bar chart showing operation of the equipment over a month.

Problem is that on chart I have again decimal values and not time, use only measure in value box seems to be impossible

Thanks in advance for support

[DenniD]

Dear Expert, 

this post is from 2017 so I hope there is already a proper solution from Power BI to show the HH:MM in Y-Axis?
Seems Tableau able to do that just fine

Regards,

Denni

[v-jiascu-msft · Accepted solution]

Hi @kadapavel,

I am afraid there isn't a feature like this by now. You can submit or vote an idea here: field-of-duration-type.

Please reference: 

1. Display-duration-as-HH-MM-SS-on-Y-axis

2. Aggregating-Duration-Time

3. Duration-as-Y-Axis

BUT, there is a workaround. Though it isn't prefect. Using a R visual.

library(ggplot2)
ggplot(data = dataset) + geom_bar(mapping = aes(x = Date, y = Column), stat = "identity")

Best Regards!

Dale

[Anonymous]

@v-jiascu-msft  Thanks. Could you please share me what R code should i use for line graph. I too want to show time on Y - Axis.

Thanks,

Shubham 

[kadapavel]

Hello v-jiascu-msft

Thank you very much! That seems to be only solution...

Hopefully the time or duration will be implemented soon as more people are using the Power BI for different data analytics.