Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am tryting to achive this
I have data in Seconds and In I have coverted it to hh:mm:ss using this http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486.
I was able to display it like below(as Second) but could not display it as hh:mm:ss on the graph,
Yeah, because there is no true "Duration" format, when you convert it to HH:MM:SS it ends up as text instead of a numeric data type. What is really needed is a "Duration" format that leaves it as numeric seconds but displays as HH:MM:SS. It's been requested for years but the product team has never done it.
They now have a duration data type, but don't go over 24 hours -- it gets confused
User | Count |
---|---|
84 | |
79 | |
70 | |
47 | |
41 |
User | Count |
---|---|
108 | |
52 | |
50 | |
40 | |
40 |