Heatmap with max color defined by a query

Hi all.

Recently I was preparing a panel for a single instance using a gauge. It used a transformation to select from a query the max value for the panel, and get coloring based on that.

Now, there are several instances and I need to move to a heatmap. However, the transformation for max value is not reflected in the color scale.

I am using grafana 10.1 prerelease. Is this a known issue, of am I doing something wrong?

Thanks in advance.