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.
I have some data like this.
Username | Adding Year | Category |
A | 2016 | Account01 |
B | 2016 | Account01 |
C | 2016 | Account01 |
D | 2016 | Account01 |
E | 2016 | Account01 |
F | 2016 | Account01 |
G | 2016 | Account01 |
H | 2016 | Account01 |
I | 2016 | Account01 |
J | 2016 | Account01 |
K | 2018 | Account01 |
I grabbed this data and create a Line chart and the result for the data was......
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
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.
Solved! Go to Solution.
Hi,
This is the result i got. You may download the file from here.
Hope this helps.
Hi,
This is the result i got. You may download the file from here.
Hope this helps.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |