How to use Prometheus value as Timestamp

Hi, does anyone know if it is possible to use a Prometheus metric value that happens to be a timestamp as the timestamp when that metric is graphed in Grafana?

Our metric returns a value such as 1690396973. We can convert this into a time value by changing the unit to date/time, however I am unable to see a way to use this returned value as the primary timestamp in the panel.

This is the best I could come up with, where the returned metric value time is on the Y axis and the native Prometheus timestamp is on the X axis. We would really like to be able to use the results of that query as the timestamp on the X axis and disregard the Prometheus timestamp entirely. Is something like that possible?

My query currently is something like this:

test_metric{label=“label”} * 1000

@kvsmoove Is your issue resolved? Please let me know how did you achieve that? Thanks in advance.

It was not able to be resolved, we ended up moving to a different data source for that product that had strict timestamp requirements.