Unable to build an visualization with measures

[Shivaraju]

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 

[v-qiuyu-msft]

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 

[Shivaraju]

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 

[v-qiuyu-msft · Accepted 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