Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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] ) )
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] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |