March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi ,
I want to show the average resolve time for the issues handle by user. So i have a column which has the Total time take for resolving an issue in hh:mm:ss format. However when i create an average resolution time by dax it populates this value in decimal point instead of the hh:mm:ss. I want to put this average resolution time in a line anc clustered column chart under Line values and show this data in hh:mm:ss format.Could you please advise how i can show in the lines values in hh:mm:ss format.
I have been able to change the format but now the format type is "Text" and I cannot add any conditional formatting to the average time if it's above a certain amount. Conditional Formatting on "Text" will only work for what the data "Contains"
Hi,
For example, you have a table below:
You can write a measure to get average time:
avgTime = Format(AVERAGE(timeAvg[time]), "HH:MM: SS")
Then you can see the result is in time format.
That worked for me Thanks
This is just what I need to do but I can not make it work.
This has worked for me, but when I try to change the visual to a graph (line, bar or column) the graph is blank. why is this?
same situtation here. Did you get a solution?
Have you already came across a solution? Got the same problem here 😞
User | Count |
---|---|
122 | |
99 | |
89 | |
74 | |
66 |
User | Count |
---|---|
138 | |
115 | |
115 | |
98 | |
98 |