topic Re: how to add weekly target base line in line and stacked column chart from a annual target database. in DAX Commands and Tips

how to add weekly target base line in line and stacked column chart from a annual target database.

Anonymous — Wed, 06 Jan 2021 14:22:15 GMT

I want to create above line chart with weekly target base line. I have annual target list and booking list as under. Please advice how to set weekly target against achieved ffe same as above graph in power bi.

Target List

A/C Owner Name	Target in FFE	Year
Raja	500	2020
Rani	200	2020
Shilpa	400	2020
Priyanka	500	2020
Raja	700	2021
Rani	700	2021
Shilpa	700	2021
Priyanka	700	2021

Booking List

Week	Customer code	FFE Volume	Account owner
1	123456	25	Raja
1	7891011	25	Rani
2	123456	40	Shilpa
2	7891011	40	Rani
3	123456	100	Shilpa
4	7891011	100	Priyanka
4	123456	100	Shilpa
5	7891011	100	Priyanka
5	123456	100	Shilpa
5	7891011	100	Priyanka
6	123456	100	Shilpa
6	7891011	50	Priyanka
6	7835abrd	50	Rani
6	fgthdfg56	100	Rani

Re: how to add weekly target base line in line and stacked column chart from a annual target database.

amitchandak — Wed, 06 Jan 2021 14:31:56 GMT

Anonymous , doses booking has year.? Date ?

Do want to split target weekly or show the same for all weeks.

In case you have date in booking and you want to show the same target, these blogs can help

powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

PowerBI 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-Convert-to/ba-p/1476400

Re: how to add weekly target base line in line and stacked column chart from a annual target database.

Anonymous — Wed, 06 Jan 2021 14:39:36 GMT

amitchandak : yes booking list has date . and yes want to split target weekly. is it possible to create PBIX. may be that will be more helpful for me to understand formula crearly.

Re: how to add weekly target base line in line and stacked column chart from a annual target database.

amitchandak — Wed, 06 Jan 2021 15:09:02 GMT

Anonymous , did you check my blogs, they have pbix links. for what I had done.

I made it day level