Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
f I have some data like this.
| Username | Adding Year | Category |
| A | 2016 | Account |
| B | 2016 | Account |
| C | 2016 | Account |
| D | 2016 | Account |
| E | 2016 | Account |
| F | 2016 | Account |
| G | 2016 | Account |
| H | 2016 | Account |
| I | 2016 | Account |
| J | 2016 | Account |
| K | 2018 | Account |
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
Now in my chart show 2016 = 10 and 2018 = 1
following this image
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)
Anybody, please help me.
Thank you for all answer.
Could you please provide more details of your requirement
Hi saranp780,
What does "10" and "11" mean? How to achieve the count value based on your posted table? Could you please provide more details about you logic to create the line chart?
Regards,
Jimmy Tao
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |