Forum Discussion
Relationships target table-calendar visual graph
Syndicate_Admin ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Refer these blogs if they can help
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
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
Good attachment to the excel document. I don't have it in power BI, but I still try it.
In the charts tab is what the target line, the first chart, and the second chart should look like to me the sum of the whole year every week.