Forum Discussion

Umarsalamat's avatar
Umarsalamat
Frequent Visitor
3 years ago

Auto Callouts/Text on Line Chart based on Formula or Criteria

Hi,

 

In datasets most of the times we are encountered with outliers. For Line Chart, I want support if someone can guide a way to assign text (stored in one column) against a datapoint whenever it breaches a certain threshold. e.g What is the way if I want to show Text given in Remarks Column below whenever Score value is >7

WeekScoreRemarks
W13.1 
W22.3 
W33.4 
W44.2 
W55.1 
W68.9Force Majeure
W72.2 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Umarsalamat ,

    Please try below steps:

    1. create a measure with below dax formula

    Measure =
VAR cur_score =
    SELECTEDVALUE ( 'Table'[Score] )
VAR _value = 7
RETURN
    IF ( cur_score > _value, "Force Majeure" )

    2. add a table visual with fields and measure

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Umarsalamat's avatar
    Umarsalamat
    Frequent Visitor
    3 years ago

    Thank You. The Reason/Remarks Column is Dynamic and team based on situation will insert the remarks in case of abnormal scores. So based on criteria of >7, The callout on Line chart need to be updated like below,

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Umarsalamat ,

      Please try to add "Measure " to Tooltips.

      Best regards,
      Community Support Team_ Binbin Yu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • Umarsalamat's avatar
        Umarsalamat
        Frequent Visitor
        3 years ago

        Thanks for you time. I am looking for solution other than tool tip so that daily or weekly trends can be shared as snap over whstapp with clearly mentioned reasons of threshold breach