Forum Discussion

jtemes's avatar
jtemes
Icon for Helper I rankHelper I
3 years ago
Solved

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 m...
  • amitchandak's avatar
    3 years ago

    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's avatar
    3 years ago

    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.