How to create a customize line chart?

[saranp780]

I have some data like this.

Status	Title	Name	Surname	Deparment	License Type	Adding Date
Active	Mr.	Susan	Simon	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Tennassi	Koo	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Henry	Wu	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Oven	Shew	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Vin	Benzence	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Louis	Lee	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Adam	Young	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Peter	Parker	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Sam	Smile	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	VVV	Shark	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	SS	Jandee	Sale	Office 365 Enterprise E3	16/9/2016
Active	Mr.	Andrew	Sundaen	Sale	Office 365 Enterprise E3	17/5/2018

I grabbed this data and create a Line chart and the result for the data was......

But I want the data to display like this; 2016 = 11 and 2018 = 12

How can I do this graph to show what I want?  (The 11 and 12 are from count from each row) Just so you know

Like in the picture I've created in another program(Following picture)

following this image

Anybody, please help me. It's a kind of sum data of 2016 and when 2018 then sum of 2016+2018. But when I put my logic in the measure I can't create a line chart so now, I don't know how to create a chart that my requirement wants to know how many users per category that register all the year as a trend?

Thank you for all answer.

[Ashish_Mathur]

Hi,

I have solved the same problem here.  Please refer to my PBI file which i shared with you there.

[MariaP · Accepted solution]

HI @saranp780

Power BI has inbuilt 'Quick Measure's which writes code for you.

Add this as a Measure in your table and drag to the Values area. Use your 'Adding Date' as the Axis. 

Count of License Type RunningTotal By Adding Date = 
CALCULATE(
	COUNTA('Community'[License Type]),
	FILTER(
		ALLSELECTED('Community'[Adding Date]),
		ISONORAFTER('Community'[Adding Date], MAX('Community'[Adding Date]), DESC)
	)
)

Your results should work as required,

Cheers.

[saranp780]

I solved my problem with your giving solution. Thank you.

[prateekraina]

Hi @saranp780,

What have you placed in Axis and Value of the visual?

Also, have you correctly assigned data types?

Prateek Raina