Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Yonko
Helper I
Helper I

Need horizontal stacked bar chart with target line

Hello. I making a vizual to show different kinds of working hours (3 measures) vs. plan hours and there is a problem - i want to use stacked horizontal bar chart with line for target value, and now i'm unable to make it.

There are two vizuals - first one is standard stacked bar chart, and i tried to add target line constant line, but it works incorrectly - there are may be different plans for different people, but line shows one value for all. The second one is bullet chart by OKVIZ and it shows targets correctly, but it works only with one measure (i used all hours together in this case), but i'd like to show different types of hours.

There is an option to use vertical bar chart with line and it works correctly, but the problem that it's not very convenient to use vertical chart with names as category - i'd prefer to stay with the vertical one.

Also i tried to search for other custom visual but found nothing, so if you'll help me i'll be very glad 🙂

image.png

1 ACCEPTED SOLUTION

Well, it isn't the solution that i was looking for. Instead i just substracted from planned hours all hours together and added this measure as unspent hours, and after that added total summ marker - it isn't the perfect solution, but it works.

Yonko_0-1664033997490.png

 

View solution in original post

3 REPLIES 3
TiagoLugatto
Frequent Visitor

https://github.com/data-goblin/powerbi-macguyver-toolbox/blob/main/bar-charts/bullet-chart/pbix-form...
This solution is the best I have discovered,
incredibly simple and within the standard PBI capabilities

TiagoLugatto_0-1702505977081.png

 

amitchandak
Super User
Super User

@Yonko , Try if bullet chart can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380755?tab=overview

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Well, it isn't the solution that i was looking for. Instead i just substracted from planned hours all hours together and added this measure as unspent hours, and after that added total summ marker - it isn't the perfect solution, but it works.

Yonko_0-1664033997490.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors