Color gradient, dynamic minimum and maximum values

[jtemes]

Hi all

I am using Gradient conditional formatting over a Matrix vith values and subtotals. 

When I select Apply to Values and Totals, the minimum and maximum have to be fixed. Is there any way to make this dinamyc according to the value of the field?

Thanks for your help

[amitchandak · Accepted solution]

@jtemes , I doubt that. But using field value you can use a measure. But creating a gradient using measure , means you need to create that many conditions

example 

Color =

Switch(True(),

[Measure]< .1, "Light green",

[Meausre] <.5, "Green",

"Dark Green")

You can use hexcode with #

Use the color measure in conditional formatting using field value option

[Ritaf1983 · Accepted solution]

Hi @jtemes 
This can be accomplished using Dex formulas.
Here is a link to a video that explains how to do this:
https://www.youtube.com/watch?v=s9ck7xx85mA

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@jtemes , I doubt that. But using field value you can use a measure. But creating a gradient using measure , means you need to create that many conditions

example 

Color =

Switch(True(),

[Measure]< .1, "Light green",

[Meausre] <.5, "Green",

"Dark Green")

You can use hexcode with #

Use the color measure in conditional formatting using field value option