Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have two sheets, one is sales, and the other is target sales. in the sales is a sales date with all its data, Day, Quarter and so on, but in the target sheet, only the target year is shown as 2020. My dilemma is that I want to create a line column chart showing the sales from the sales sheet vs the Target sales in the target sheet, per month. Of course, since there is no link between them or month in the target, the data is not working, like this:
And here are the sheets:
Sales:
Target:
My question is, how do I link the two properly or induce a month value from the sales table to the target table if that is applicable?
Thank you
Hi @Kareem_Amr_IT ,
I'm a little confused. What's the target for each month if you only have year in target target table, average?
Best Regards,
Jay
@Kareem_Amr_IT , I have two blogs and a couple of videos on this topics. But I think this should help
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-C...
Others:
Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...
https://www.youtube.com/watch?v=yPQ9UV37LOU
https://www.youtube.com/watch?v=6lzYOXI5wfo
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |