Forum Discussion

galvar1975's avatar
galvar1975
Frequent Visitor
7 years ago
Solved

Date and Time X-axis

I have a table with values every 15 minutes, I would like to create a chart with hours in the x-axis, and the magnitude of the measured variable (Potencia R(MW)) in the Y-axis.     I have cr...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi galvar1975 

     

    If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

     

    Best regards,

    Dina Ye

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi galvar1975 

 

I figure that you’d like to create the chart with hours in axis, and MW in the values.

So I’ve added the Hour column in your fact table and place it in the axis.

Column = HOUR(Table1[FECHA-dato])

Best regards,

Dina Ye

galvar1975's avatar
galvar1975
Frequent Visitor
7 years ago

I have to retrieve the hours and minutes, and it would be great if that could be done with a measure!

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi galvar1975 

     

    We’re not able to set the measure on X-axis. For any column to be used as an axis value, it should be a category.

    So in this case, it’s preferred to use column rather than measure.

     

    Best regards,

    Dina Ye

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi galvar1975 

       

      If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

       

      Best regards,

      Dina Ye