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.
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 |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |