measure to custom column (data to be used in legend )

[Gokul]

Hi all,,
I need to turn the data in table into a chart and I cannot use the measure on the legend or axis on chart

Avg = var dayNo=INT(AVERAGE('Group Query'[mins])/1440)
var hourNo=INT(MOD((AVERAGE('Group Query'[mins])),1440)/60)
var minuteNO=MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)
var days=if(dayNo>1,dayNO&" Days ",if(dayNo=1,dayNO&" Day "))
var hrs=if(hourNo,FORMAT(hourNo,"#0")&" Hrs ",if(hourNo=1,FORMAT(hourNo,"#0")&" Hr "))
var mins=if(minuteNO>1,FORMAT(minuteNo,"#0")&" Mins",if(minuteNO=1,FORMAT(minuteNo,"#0")&" Min",if(minuteNO=0,"")))

return CONCATENATE(days,CONCATENATE(hrs,mins))

[Gokul]

 I need to turn the data in table into a chart and I cannot use the measure on the legend or axis on chart

My Measure:
AvgTurnaroundTime= var dayNo=INT(AVERAGE('Group Query'[_mins])/1440)
var hourNo=INT(MOD((AVERAGE('Group Query'[mins])),1440)/60)
var minuteNO=MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)
var days=if(dayNo>1,dayNO&" Days ",if(dayNo=1,dayNO&" Day "))
var hrs=if(hourNo,FORMAT(hourNo,"#0")&" Hrs ",if(hourNo=1,FORMAT(hourNo,"#0")&" Hr "))
var mins=if(minuteNO>1,FORMAT(minuteNo,"#0")&" Mins",if(minuteNO=1,FORMAT(minuteNo,"#0")&" Min",if(minuteNO=0,"")))

return CONCATENATE(days,CONCATENATE(hrs,mins))

[v-juanli-msft · Accepted solution]

Hi @Gokul

Create measures

dayNo = INT(AVERAGE('Group Query'[mins])/1440)

hourNo = INT(MOD((AVERAGE('Group Query'[mins])),1440)/60)

minuteNO = MOD(MOD((AVERAGE('Group Query'[mins])),1440),60)

Then create  a column

column = 
var days = if([dayNo]>1,[dayNO]&" Days ",if([dayNo]=1,[dayNO]&" Day "))
var hrs = if([hourNo],FORMAT([hourNo],"#0")&" Hrs ",if([hourNo]=1,FORMAT([hourNo],"#0")&" Hr "))
var mins2 = if([minuteNO]>1,FORMAT([minuteNo],"#0")&" Mins",if([minuteNO]=1,FORMAT([minuteNo],"#0")&" Min",if([minuteNO]=0,"")))
Return CONCATENATE(days,CONCATENATE(hrs,mins2))

Best Regards

Maggie