How to plot daily sales budget starting form annual value

[giroldoale]

Hi everyone,

I 'm facing with annoying issue.

I have an annual sales budget declined by customer and business Line.

My goal is to plot a line graph where there is the budget in a daily vision (assuming linearity in the distribution, so a straight line)  and the actual values of invoices always in a daily basis.

I've to obtain something like this

[v-shex-msft]

Hi @giroldoale,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Jihwan_Kim · Accepted solution]

Hi, @giroldoale 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are written in the sample pbix file by numbering the steps and you can follow the steps.

https://www.dropbox.com/s/1xtjq51x1pcm994/giroldoale.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak]

@giroldoale , refer these two blogs should help

https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...

https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-...