October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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 metrics? For example: Metric 1 has a target of 5%, Metric 2 has a target of 22%, Metric 3 has a target of xx %. Thos target line would extend across the line graph. This would allow to see where each metric is relative to target each month.
TIA for any help.
Solved! Go to Solution.
Go to Analytics area under visualizations and Click on Y-Axis Constant Line and you can add multiple target lines here and format accordingly
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.
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.
Go to Analytics area under visualizations and Click on Y-Axis Constant Line and you can add multiple target lines here and format accordingly
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |