Forum Discussion

jitpbi's avatar
jitpbi
Icon for Post Patron rankPost Patron
6 years ago
Solved

Highlight 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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.