Forum Discussion
Solved
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 PowerB...
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.
Thank you SO much!