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, and for homes that are farther from completion the color is red. I would now like to add additional functionality so that the user can toggle the column that the color is based on between "% Construction Complete" and "> 90 Days Since Last Inspection Date". The new column is a TRUE/FALSE flag and I want the plotted addresses to show as red if the last inspection for that property is greater than 90 days ago. 

 

I've tried to create a standalone table for the toggle items: "Days Since Last Inspection" and "Percent Complete", and next, both a column and a measure (separately) which try to return the % complete if the filter is "Percent Complete" and 1 or 0 if the "Days Since Last Inspection" flag is TRUE/FALSE. I get aggregation errors. I'm not sure what to try next.

 

Thank you,
Nick

  • 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] )
        )
    

     

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    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] )
        )