Forum Discussion
jitpbi
Post Patron
Post PatronHighlight Maximum Deviation
Hi, On a line chart visual, "actual sales" and "target sales" are on Y-axis and "date" is on X-axis . On the secondary Y-axis, showing the "difference" (actual and target sales). I have to highl...
jitpbi
First create a difference column between actual and target sales:Diff= VAR a = [actual sales]-[target sales] Return VALUE(RIGHT(a,LEN(a)- IFERROR(FIND("-",a),0)))Then flag the highest difference with measure:
Measure = IF(SUM('Table'[Diff])=CALCULATE(MAX([Diff]),ALL('Table')),1,0)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jitpbi
First create a difference column between actual and target sales:
Diff=
VAR a = [actual sales]-[target sales]
Return
VALUE(RIGHT(a,LEN(a)- IFERROR(FIND("-",a),0)))
Then flag the highest difference with measure:
Measure = IF(SUM('Table'[Diff])=CALCULATE(MAX([Diff]),ALL('Table')),1,0)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.