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.

[EugeniaCastilla]

hey ruben, I know this is an old post but i was wondering if you could help me, I am doing as you say, getting a vMin and vMax variable for the min and max values of my 3 expressions but it isnt working, as the values given as max and min are not correct so there is an issue with the rangemax but i dont know what it is, the expr are master measures that read from other master measures, can this have somehting to do with this?