Display time measures in visuals

[Anonymous]

I need to display average time between different dimensions and would like to use these time differences in graphs. For example, I may have a process that takes on average 5 min in location A and 5min30seconds in location B. I want to plot those numbers out on a graph.

However, I can't find a visual that allows time dimensions as measures. If I convert those numbers into seconds I will get numbers that users won't be able to understand. Such as 300 seconds and 330 seconds. 

Any ideias on how to solve this?

[v-danhe-msft]

Hi @Anonymous ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He

[Anonymous]

Hi Daniel,

Thanks for reaching out. The example below illustrates what I mean. I have requests that take time to happen and I want to plot a graph to compare the requests. I need to put the time measure on the Y-axis.

---

@v-danhe-msft wrote:

Hi @Anonymous ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He

---

[v-danhe-msft]

Hi @Anonymous ,

Based on my test, I am afraid you could not use the time measure in Y-axis. Both X-axis and Y-axis chould only put columns intsead of measures and the value bucket could put measures.

Regards,

Daniel He

[Anonymous]

Daniel, thanks for trying this out. I don't think there is a solution. Maybe in the future a new visual will be able to handle this.