Forum Discussion
How create a stacked bar chart 100% completion Line?
sahooak, sorry for the delay, I was travelling.
Please find attached an example.
If it helped you, you can give kudos and accept it as a solution.
Hello GrowthNatives Thank you for your help. How can i add forecast value after the constant line?
Yes sahooak
We’ll combine:
• Bar chart for Actual % Achieved
• Line (or marker) for Forecast
• Constant dotted line at 100%
Create core measures
DAX
% Achieved =
DIVIDE([Actual Shipment], [Forecast Shipment], 0)
Forecast % = 1 // represents the target 100% line logically
If you want to display Forecast shipment values as an actual bar (beyond 100%), also create:
DAX
Forecast Shipment % =
DIVIDE([Forecast Shipment], [Forecast Shipment], 0) // always 1, but used for scaling alignment
or, if you want to show absolute forecast values on a secondary axis:
DAX
Forecast Value = [Forecast Shipment]
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀[Explore More]
Hello GrowthNatives For forecast value I need to use Multi-row card, right? Then I need to group it to the bar char.
Thank you,
AkHi sahooak , If you want the forecast values to appear visually aligned with bars then use the Clustered Bar Chart (or Stacked Bar Chart if showing remaining %).
Add both measures:
• Actual % (bar length)
• Forecast Value (as a separate measure or label)
In Data Labels → Customize Series:
• Turn on labels for Forecast Value only.
• Position them “Outside end” of the bar.
• Format as currency, or whatever unit your forecast uses.
Add your dotted 100% constant line (from Analytics pane).
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀[Explore More]