Target vs actual with target line per accountmanager - column chart

[TomBelgium]

Hi there,

I have following dataset:

Accountmanager	BU	Month Nr	Sales	Month Target
X	A	1	1500	2000
Y	A	1	2500	1800
X	B	1	200	500
Z	A	1	1500	2500
X	A	2	200	2000
Y	A	2	400	1800

The month target is fixed. It is a yearly target which is divided by 12 so every month has the same target for the combination BU and AccountManager.
I want to display a column chart in which I see per month the accountmanager and his target, preferably in the same column (or with a line or sth).

I managed to create a comlumn chart which displays the sales per accountmanager per month but I can't get the target in there. All suggestions help

[amitchandak]

@TomBelgium , Based on what you shared you should be able to use sum of target on line in clustered column line visual

If data is not distributed

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

[TomBelgium · Accepted solution]

Hi there,

I used this video to make it work: Targets vs Actuals Chart in Power BI - YouTube

Thanks for the reply!