Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a data which contains the Time column, and I need to find an "Average" Time on each segment.
I have used this DAX function Average Idle Time = FORMAT(CALCULATE(AVERAGEX(Sheet1,Sheet1[Idle Time])),"HH:MM:SS")
and and I created a Measure & I got the result. but I can't able to build a visualization since Measure is in text format. 😞
Does anyone can help me with the solution, or with DAX function to finding an average TIME.
Regards
Shiva
Solved! Go to Solution.
Hi @Shivaraju,
It's not supported to display time duration in Y axis of the column chart. To workaround the issue, you can either convert time to number or use R visual. See: https://community.powerbi.com/t5/Desktop/Display-time-in-Y-axis-using-Power-BI-clustered-column-char...
Best Regards,
Qiuyun Yu
Hi @Shivaraju,
>>I can't able to build a visualization since Measure is in text format
Which visual do you want to visualize the measure data? I see you already put the measure in a table visual. Please share detail information about your desired result.
Best Regards,
Qiuyun Yu
Hey Qiuyun Yu , Thanks for the reply.
I want to build a column chart! but it's not allowing me to do that 😞
I can see the average time in a table visual! but I can't build any visualize except the table.
.....
Regards
Shiva
Hi @Shivaraju,
It's not supported to display time duration in Y axis of the column chart. To workaround the issue, you can either convert time to number or use R visual. See: https://community.powerbi.com/t5/Desktop/Display-time-in-Y-axis-using-Power-BI-clustered-column-char...
Best Regards,
Qiuyun Yu
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |