Forum Discussion

nicktayl's avatar
nicktayl
Helper I
9 years ago
Solved

Dynamic Map Color Saturation Based on Toggle

Hi,   I have a map with which I've plotted home addresses. I for color saturation, the column I am using is "% Construction Complete". For homes that are closer to completion, the color is green, a...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    nicktayl,

     

    You may refer to the following DAX that adds a measure.

    Color Saturation =
VAR itemValue =
    IF ( HASONEVALUE ( Table2[item] ), VALUES ( Table2[item] ) )
RETURN
    SWITCH (
        itemValue,
        "Days Since Last Inspection", MAX ( Table1[> 90 Days Since Last Inspection Date] ),
        "Percent Complete", MAX ( Table1[% Construction Complete] )
    )

     

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

nicktayl,

 

You may refer to the following DAX that adds a measure.

Color Saturation =
VAR itemValue =
    IF ( HASONEVALUE ( Table2[item] ), VALUES ( Table2[item] ) )
RETURN
    SWITCH (
        itemValue,
        "Days Since Last Inspection", MAX ( Table1[> 90 Days Since Last Inspection Date] ),
        "Percent Complete", MAX ( Table1[% Construction Complete] )
    )