Targets Without Stacked Column Chart

[TCData]

Looking to put a target column in the background with actuals in the foreground on same chart. It is similar to a stacked column solution with total of the column at the top, but not quite what I need. Let's say my target is 1000 and the actual is 800. I do not want to have a stacked column chart with 800 in one series and 200 on top with 1000 as the total. It is very specific that the target has to sit in the backgorund so it looks like the actuals are "filling" it.

[TCData]

Thank you. I was hoping to find a visual, but after searching I cannot find one. Doing it this way was my next option.

[TCData]

Closer, but still not what I am looking for. See below only as a column chart where the light blue is the target with a data label and the dark blue is the actual value with a data label

[Anonymous · Accepted solution]

Hi @TCData ,

I created a sample pbix for you, please check whether that is what you want.

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[TCData]

This is a great solution! Is there any way to get the Target to show a data label? For example, can 17 show for P6?

[TomMartens]

Hey @TCData ,

I guess you are looking for a bullet chart, go to the store for custom visuals and search for bullet:

Hopefully, this provides what you are looking for.

Regards,

Tom