Forum Discussion
conditional formatting diagram background
Hi,
When the blue line (is value) intersects the red dashed line (limits), I want the background color of the chart to change.
A fixed value for the limits cannot be used because it is variable.
Does anyone have an idea how I can solve this ?
Much Thanks !
Hi Anonymous ,
You could create a measure to determine if two lines have the same value.
If both lines have values from columns:
measure = IF(selectedvalue([line1])=selectedvalue([line2]),1,0)
If both lines are measures:
measure = IF([line1]=[line2],1,0)
Then use the value of this measure as the rule of conditional formatting.
If I misunderstood your meaning, please share more details.
Best Regards,
Jay
1 Reply
Hi Anonymous ,
You could create a measure to determine if two lines have the same value.
If both lines have values from columns:
measure = IF(selectedvalue([line1])=selectedvalue([line2]),1,0)
If both lines are measures:
measure = IF([line1]=[line2],1,0)
Then use the value of this measure as the rule of conditional formatting.
If I misunderstood your meaning, please share more details.
Best Regards,
Jay