Forum Discussion
How create a stacked bar chart 100% completion Line?
- 10 months ago
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 For forecast value I need to use Multi-row card, right? Then I need to group it to the bar char.
Thank you,
Ak
Hi 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]