Using a measure as the axis of a column chart

[sirros_iot]

Hello all,

          A have a Power BI archive by direct query mode and I'am receiving timestamp values.

                             

         In YELLOW, timestamp.                                                     [_ts]

         In RED, a measure that changes timetamp to datetime.  [.TimeATFull]

         I would like to use the measure [.TimeATFull] as the axis of the column chart, one datetime axis.

*I can't create calculated columns because of the direct query mode.

         Is there a way of doing that? 

Regards,

Diego 

[TomMartens · Accepted solution]

Hey,

unfortunately you can't use measures as an axis at the moment, just columns are supported for the use on axis.

For this reason you have to consider to create the "measure" in your datasource.

Hopefully this gives you an idea

Regards

Tom

[sirros_iot]

Thank you for the answer! I'll see what I can do.

Regards,

Diego