Need horizontal stacked bar chart with target line

[Yonko]

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 🙂

[TiagoLugatto]

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

[amitchandak]

@Yonko , Try if bullet chart can help

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

[Yonko · 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.