Forum Discussion

i820017's avatar
i820017
Icon for Resolver II rankResolver II
5 years ago
Solved

HH:MM:SS Will Not Chart

 

I am trying to chart data that is in the format HH:MM:SS along the Y-Axis and CallMonth along the X-Axis, and I am not able to do so. The DAX that I am using is below.                     

ACW___Avg =

VAR a = [ACWAvg]

VAR hours = INT ( a / 3600 )

VAR minutes = INT ( MOD ( a - ( hours * 3600 ), 3600 ) / 60 )

VAR seconds = ROUNDUP ( MOD ( MOD ( a - ( hours * 3600 ), 3600 ), 60 ), 0 )

RETURN

TIME ( hours, minutes, seconds )

 

 

When I enter this data into a matrix, the data compiles as seen below.

 



 


However, when I enter this data into a line graph, the data does not chart. Specifically, when I try putting ‘ACW___Avg’ into ‘Values’ under the ‘Fields’ list under ‘Visualizations’, it does not work. In fact, Power BI puts ‘ACW___Avg’ into ‘Tooltips’ automatically as seen below.

 

 

 

Below is a picture of the line graph that I get -- as you can see, there is no line graph 😞   

 

 

 

Does anyone know how to fix this?

 

Thanks
Dan

 

  • i820017's avatar
    i820017
    5 years ago

    Ok...I will accept this as a solution...thanks.

3 Replies

  • i820017 , As this is a text value, I doubt you can use that in values of visual like bar pie, etc. But I think, if there is a value already there in visual, you should be able to use this measure or tooltip

    • i820017's avatar
      i820017
      Icon for Resolver II rankResolver II

      Ok...I will accept this as a solution...thanks.

    • jmsousatavares's avatar
      jmsousatavares
      Regular Visitor

      hello,
      and if the variable is in date / time format, is possible to use this in the y axis?
      I am trying to do that but power bi always create a "count of" ans shows the number of ocurrences and not the time value that I want.