Forum Discussion
Benchmark line
Hello,
As a beginner in PowerBi, I would like to know how to have a benchmark line steady and aligning with the Y axis
Here is the graph from PowerPoint
Here is the graph from PowerBi (different data)
How can I get the PowerBi to look like the PowerPoint graph?
Thanks in advance for your support and advise.
Hi MarleneHutt ,
To achieve a steady benchmark line aligned with the Y-axis in Power BI, follow these steps:
Using Analytics Pane :
Select the Bar Chart where you want to add the benchmark.
Click on the "Add further analysis to you visual" pane (found in the Visualizations section).
Look for "Constant Line" and click "Add".Set the value of the constant line to your benchmark value (e.g., 19 or 61 as seen in the images).
Customize:
Label: Show the value (e.g., "Benchmark = 19").
Color: set your desired color (red/orange).
Line style: Solid, dashed, or dotted.
Transparency: Adjust for visibility.Please mark this post as solution if it helps you. Appreciate Kudos.
MarleneHutt , please accept my post as solution if it helps you.
3 Replies
Hi MarleneHutt ,
To achieve a steady benchmark line aligned with the Y-axis in Power BI, follow these steps:
Using Analytics Pane :
Select the Bar Chart where you want to add the benchmark.
Click on the "Add further analysis to you visual" pane (found in the Visualizations section).
Look for "Constant Line" and click "Add".Set the value of the constant line to your benchmark value (e.g., 19 or 61 as seen in the images).
Customize:
Label: Show the value (e.g., "Benchmark = 19").
Color: set your desired color (red/orange).
Line style: Solid, dashed, or dotted.
Transparency: Adjust for visibility.Please mark this post as solution if it helps you. Appreciate Kudos.
Thank you SO much!
MarleneHutt , please accept my post as solution if it helps you.
