Grid chart evaluate per dimension

[Jonathan_Alm]

Hi,

I am looking into creating a grid chart (heatmap) that will display products on the Y-axis and year-month on the X-axis. The measure is sales.

I would like the colors of the heatmap to only evaluate per product. Not the whole chart.

The chart will be used to see if any product has for example low/high sales, missing sales (due to problems with invoicing etc) 

Example

	2023-04	2023-05	2023-06	2023-07	2023-08	2023-09
Product A	30	50	40	50	50	60
Product B	10	30	40	40	30	50
Product C	100	200	400	200	400	600
Product D	50 000	60 000	70 000	60 000	60 000	90 000

In this case 2023-04 that has the lowest sales (per product) and should have the same colour if I manage to make the chart evaluate per dimension. 

Any idea of how to manipulate the chart to do this?

Kind regards Jonathan