Benchmark line

[MarleneHutt]

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.

[FarhanJeelani · Accepted solution]

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]

Thank you SO much!

[FarhanJeelani · Accepted solution]

@MarleneHutt , please accept my post as solution if it helps you.

[FarhanJeelani · Accepted solution]

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.