Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have these fields in my EXCEL sheet:
Duration
0:58:01
1:25:32
0:00:59
When I bring it into PowerQuery it formats it as:
How do I force PowerQuery to bring in this field as just the text?
If you convert them to text, they will sort alphabetically and you won't be able to do analysis easily (min, max, avg time). A good practice is to bring them in as time or duration, do your analysis, and then FORMAT it how you like in the measure/visual.
Calculate and Format Durations in DAX – Hoosier BI
Pat
Hi, right click on Duration, Transform, time only