Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
saranp780
Helper III
Helper III

How to create a customize line chart?

 I have some data like this.

 

UsernameAdding YearCategory
A2016Account01
B2016Account01
C2016Account01
D2016Account01
E2016Account01
F2016Account01
G2016Account01
H2016Account01
I2016Account01
J2016Account01
K2018Account01

 


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

 

line.jpg

 

 

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

 

How can I do this graph to show what I want? What I want are 2016 = 10 and 2018 = 11

 

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

 

 

 

following this image

Untitled.jpg

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.

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

This is the result i got.  You may download the file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

 

This is the result i got.  You may download the file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur I have done yet on my dataset but In my question, I can process with your giving technique.

 

But in another dataset that I want the same solution but I can't make it happen. I've already posted the new topic with my dataset. If you want to explain more solution to me. >>>Here

 

 

Thank you.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.