Forum Discussion
Benchmark line
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.
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.