Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
GuillaumeD
New Member

Metrics working on a table but not in chart

Hello everyone, 

 

I have a reporting with some metrics, i have some issue with one of them, i can use it in a table but in chart i can only use it as "tooltip" (info-bulle in french)

here an example of table

GuillaumeD_1-1688124633062.png

 

here if i swap to a chart 

GuillaumeD_2-1688124658386.png

here my metrics : 

DMC_Chat =
var vSeconds= (CALCULATE(SUM(Interactions[Heure_dmc_phone]),Interactions[Media Type]="Message",Interactions[Agent Name]<>"")*3600+CALCULATE(SUM(Interactions[Minute_DMC]),Interactions[Media Type]="Message",Interactions[Agent Name]<>"")*60+CALCULATE(SUM(Interactions[Second_DMC]),Interactions[Media Type]="Message",Interactions[Agent Name]<>""))/CALCULATE(count(Interactions[Conversation Id]),Interactions[Media Type]="Message",Interactions[Agent Name]<>"")
var vMinutes=int( vSeconds/60)
var vRemainingSeconds=MOD(vSeconds, 60)
var vHours=INT(vMinutes/60)
var vRemainingMinutes=MOD(vMinutes,60)
return
  time(vHours,vRemainingMinutes,vRemainingSeconds)

 

GuillaumeD_3-1688124715567.png

 

i tried manythings, change metrics main table, other calendar data, checked on google

I can't put the metrics in Y or X even alone (it's the same with all chart form) 

 

 

GuillaumeD_4-1688124859506.png

i have other time metrics with the same code, they are not working too, maybe it's about my formula ?

 

 

Can you help me with this

regards

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.