Forum Discussion
Relationships target table-calendar visual graph
Good morning to you all,
I have a question about the link I make between two tables and then how to represent it on a chart.
I have a database with these tables and connections between them:
Now I want to chart the sales we're having throughout the year and put a line with the goal. The problem I have is that when it comes to setting the goal it makes me the sum of the whole year and puts week by week the annual goal:
It really should look something like this:
To do this the calculation I've done has been this:
•SUMX(Objective;[ Value])
What do I have to do so that instead of adding up the value of the goal and setting the sum of the year for each week I put the amount of each week?
Thank you
5 Replies
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.
Sorry I see there's been an erro and you haven't seen the boards. How can I upload the excel is not a pbix.?
These are the connections
and just as the graph should look:
And just as it looks:
Hi Syndicate_Admin ,
Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
Best Regards,
Yuna
Well I already managed to do what I wanted. At the end add to the data model a column with the different objectives set by the company.
