Forum Discussion
Display time measures in visuals
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?
4 Replies
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
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
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
