How to show minutes or seconds in chart?

[Bit2021]

I have a dataset then receive a value in seconds.

How can I show "Probability" in seconds in the chart?

[v-jingzhang · Accepted solution]

Hi @Bit2021 

The values in the time column represent for time values or duration values? No matter which values they are, you need to convert or format them into minutes or seconds first. Then use it as Axis field in the chart. 

If they are time values, you can add a column to extract the minute or second values directly with MINUTE function or SECOND function.

If they are duration values, you can use HOUR, MINUTE and SECOND functions to extract values first and make a calculation then. For example,

minutes = HOUR([Time])*60 + MINUTE([Time]) + SECOND([Time])/60

seconds = HOUR([Time])*60*60 + MINUTE([Time])*60 + SECOND([Time])

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Kumail]

Hi @Bit2021 

If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.
 
You can send the sample .pbix file by adding it to your drive or dropbox and add the link here. 
 
Regards
Kumail Raza

[aj1973]

Hi @Bit2021 

The column Time is not converted in Seconds!, shouldn't it be a duration column? or Time?