Forum Discussion
Color gradient, dynamic minimum and maximum values
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
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
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=s9ck7xx85mAIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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
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=s9ck7xx85mAIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.