convert simple Excel chart into Power BI

[Rosie64]

Hi,

I'm trying to recreate an Excel Table in Power Bi - never thought it would seem so complex to create something so simple - maybe its just because I am a novice.  Anyway, trying to get Three different stages for documents monitored over four quarters of the year - with trendline for target.  Simple right?  Not for me - here is the chart in Excel and the data - please tell me what I am doing wrong - I get the chart created etc but maybe my data points in the imported Excel are wrong?  no idea. Thank you in advance!

	Q1	Q2	Q3	Q4
Document Revised	13	0	14	0
Approved	0	35	27	50
Remaining Documents	42	20	14	5
Target	13	27	41	55

[SivaMani]

@Rosie64, Yes, it is doable.

You may need a measure for Target,

Target = CALCULATE(
     SUM('Table'[Value]),
     'Table'[Type] = "Target"
)

Add the category to the column legend property and exclude Target at the visual level filter, add value column to column y-axis and the target measure to Line y-axis