Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

Sales Target



I would like to create a monthly running sales target based upon last years profit figure +20%, i have a calculated column which gives me last years profit + 20% but would like to show this in a line graph against YTD profit.  Probably someone cleverer than me, which think of a easy way to achieve this as i am drawing a blank!!


Many thanks

Super User
Super User

Probably start with something like this:


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

thank you, yes i can do the dax for these however i probably didint explain my problem, and i am not sure I can do what i am trying to acheive.


for example:

DateSales AchievedFY2017/18 Target
Jan-16 100,000  125,000 
Feb-16125,000 156,250 
Mar-16150,000 187,500 
Apr-16125,000 156,250 
May-16130,000 162,500 
Jun-16140,000 175,000 
Jul-16 100,000  125,000 
Aug-16125,000 156,250 
Sep-16150,000 187,500 
Oct-16125,000 156,250 
Nov-16130,000 162,500 
Dec-16140,000 175,000 


the sales figures for 2016 were as above, and i would like to add 25% onto this figures to form the sales target for the following year ie 2017.  I would then like to display these on a line graph with YTD sales and also a Sales Target to show if we are ahead or behiand target and ideally a percentage figure


I can do a calcualted column adding 25% of the 2016 sales figures and its therfore gives me the sales target for 2017, but will obviously will display on the x axis against 2016 and not 2017.  I hope this is a better explaination

Hi @tmears,


Since you can get the monthly running sales, then, based on my understanding, you need to add this running values into a line chart, together with the FY2017/18 Target value, right? On X-axis, it displays the Date column, right?


I was confused about how you want to compare the YTD sales and Sales Target? Compare the Sales Achieved in year 2016 with the target sales in year 2017? It looks like make no sense.


To elaborate your desired output, would you please draw a picture to show us your expected line graph?


Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors