Forum Discussion
Resolver IActual-Targe variance arrows
Dear Team;
Hope my message find you well !
As you can see in the screenshot below i have a table and i would like to make a "Variance Arrows with actual columns and Target line" graphic below.
Please could you support.
Thank you for advance.
dofrancis3 In the Visualizations pane, click on the "Analytics" icon (looks like a magnifying glass).
Under "Analytics", find "Constant Line" and add it.
Set the value of the constant line to the average or specific target value you want to display.Unfortunately, Power BI does not have a built-in feature for variance arrows directly. However, you can achieve this using custom visuals or by creating a measure to calculate the variance and then using conditional formatting.
To create a measure for variance:Variance = [Actual] - [Target]
Use this measure to create a new column or to conditionally format the bar chart to show different colors or icons based on the variance.
You should be able to achieve want you want with error bars
Please see this videoes with a couple of examples
2 Replies
- bhanu_gautam
Super User
dofrancis3 In the Visualizations pane, click on the "Analytics" icon (looks like a magnifying glass).
Under "Analytics", find "Constant Line" and add it.
Set the value of the constant line to the average or specific target value you want to display.Unfortunately, Power BI does not have a built-in feature for variance arrows directly. However, you can achieve this using custom visuals or by creating a measure to calculate the variance and then using conditional formatting.
To create a measure for variance:Variance = [Actual] - [Target]
Use this measure to create a new column or to conditionally format the bar chart to show different colors or icons based on the variance.
- Deku
You should be able to achieve want you want with error bars
Please see this videoes with a couple of examples