Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
2 years ago
Solved

Target line

Afternoon all:   I have a line graph that shows montly percentages across a rolling 12 month period for three metrics.  Is it possible to put a target line on the graph for each of the three metric...
  • NishPatel's avatar
    2 years ago

    Go to Analytics area under visualizations and Click on Y-Axis Constant Line and you can add multiple target lines here and format accordingly

  • v-weiyan1-msft's avatar
    2 years ago

    Hi PowerBINoob24 ,

     

    Thank you, NishPatel, for your helpful and quick response.
    My additions are as follows.
    Here is the dummy data I created.

    The fields in the line chart are as follows.

    Please select your line chart, and in the Visualizations pane, do the following.
    Line colors can be changed on your request.
    You can also set the Data label option to "on".

    Result is as below.

    For more you may refer to:

    Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn


    Best Regards,
    Yulia Yan


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.