Color Mix Table with Multiple Expressions

[zjalalacssi]

Hello everybody,

i would like to apply a color mix on a table with 1 dimension and multiple expressions in order to have a gradient color  applied for all my measures.

Please find attached an example of my Table

Thank you

[rubenmarin]

The one that looks weird is the last column, in particular those 13 hours with white background, other columns can be possible by the data they show.

Also note that using variables maxx and min values will be on totals, max an min in rows will be different. Wich ones should be max and min references?

Can you upload a sample to check?

[zjalalacssi]

i can't upload the sample i think  the app size is too big

[rubenmarin]

Maybe you need to retrieve max a min using an aggr to check at row level, ie:
Rangemax(
Max(Aggr(Expression1, WeekField)),
Max(Aggr(Expression2, WeekField))
...

Not looking beautiful and performance can be affected but I don't know if there is other way to retrieve the cells with max (or min) values. Without aggr() the variable will store the max and mins values in totals.