Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I wish to create a simple line chart which have x axis as date ( non aggregated ) and y axis as ( values as non aggregated )
I tried using python visual (above) but I want to achieve it in power bi visual.
Above image is the example of requirement.
Dummy Table given below.
Date Values
| 16-11-2022 00:00:00 | 19 |
| 16-11-2022 00:00:00 | 72 |
| 16-11-2022 00:00:00 | 5 |
| 16-11-2022 00:00:00 | 73 |
| 16-11-2022 00:00:00 | 85 |
| 16-11-2022 00:00:00 | 47 |
| 16-11-2022 00:00:00 | 1 |
| 16-11-2022 00:00:00 | 6 |
| 16-11-2022 00:00:00 | 5 |
| 16-11-2022 00:00:00 | 14 |
| 16-11-2022 00:00:00 | 12 |
| 16-11-2022 00:00:00 | 23 |
| 16-11-2022 00:00:00 | 57 |
| 16-11-2022 00:00:00 | 1 |
| 17-11-2022 00:00:00 | 9 |
| 17-11-2022 00:00:00 | 70 |
| 17-11-2022 00:00:00 | 39 |
| 17-11-2022 00:00:00 | 29 |
| 17-11-2022 00:00:00 | 74 |
| 17-11-2022 00:00:00 | 34 |
| 17-11-2022 00:00:00 | 98 |
| 17-11-2022 00:00:00 | 17 |
| 17-11-2022 00:00:00 | 30 |
| 17-11-2022 00:00:00 | 63 |
| 17-11-2022 00:00:00 | 10 |
| 17-11-2022 00:00:00 | 5 |
| 18-11-2022 00:00:00 | 29 |
| 18-11-2022 00:00:00 | 97 |
| 18-11-2022 00:00:00 | 28 |
| 18-11-2022 00:00:00 | 76 |
| 18-11-2022 00:00:00 | 34 |
| 18-11-2022 00:00:00 | 4 |
| 18-11-2022 00:00:00 | 22 |
| 18-11-2022 00:00:00 | 33 |
| 18-11-2022 00:00:00 | 97 |
| 18-11-2022 00:00:00 | 83 |
| 18-11-2022 00:00:00 | 37 |
| 18-11-2022 00:00:00 | 83 |
| 19-11-2022 00:00:00 | 55 |
| 19-11-2022 00:00:00 | 93 |
| 19-11-2022 00:00:00 | 6 |
| 19-11-2022 00:00:00 | 44 |
| 19-11-2022 00:00:00 | 40 |
| 19-11-2022 00:00:00 | 32 |
| 19-11-2022 00:00:00 | 50 |
| 19-11-2022 00:00:00 | 87 |
| 19-11-2022 00:00:00 | 30 |
| 20-11-2022 00:00:00 | 7 |
| 20-11-2022 00:00:00 | 52 |
| 20-11-2022 00:00:00 | 2 |
| 20-11-2022 00:00:00 | 11 |
| 20-11-2022 00:00:00 | 2 |
| 20-11-2022 00:00:00 | 82 |
| 20-11-2022 00:00:00 | 70 |
| 20-11-2022 00:00:00 | 96 |
| 20-11-2022 00:00:00 | 34 |
| 20-11-2022 00:00:00 | 55 |
| 20-11-2022 00:00:00 | 17 |
| 20-11-2022 00:00:00 | 6 |
| 20-11-2022 00:00:00 | 76 |
| 20-11-2022 00:00:00 | 22 |
| 20-11-2022 00:00:00 | 12 |
| 20-11-2022 00:00:00 | 85 |
| 20-11-2022 00:00:00 | 83 |
| 20-11-2022 00:00:00 | 84 |
| 20-11-2022 00:00:00 | 82 |
| 21-11-2022 00:00:00 | 58 |
| 21-11-2022 00:00:00 | 22 |
| 21-11-2022 00:00:00 | 37 |
| 21-11-2022 00:00:00 | 75 |
| 21-11-2022 00:00:00 | 78 |
| 21-11-2022 00:00:00 | 90 |
| 21-11-2022 00:00:00 | 4 |
| 21-11-2022 00:00:00 | 29 |
| 21-11-2022 00:00:00 | 40 |
| 21-11-2022 00:00:00 | 79 |
| 21-11-2022 00:00:00 | 19 |
| 21-11-2022 00:00:00 | 97 |
| 21-11-2022 00:00:00 | 33 |
| 21-11-2022 00:00:00 | 95 |
| 21-11-2022 00:00:00 | 8 |
| 21-11-2022 00:00:00 | 46 |
| 21-11-2022 00:00:00 | 30 |
| 21-11-2022 00:00:00 | 4 |
| 22-11-2022 00:00:00 | 55 |
| 22-11-2022 00:00:00 | 8 |
| 22-11-2022 00:00:00 | 37 |
| 22-11-2022 00:00:00 | 83 |
| 22-11-2022 00:00:00 | 98 |
| 22-11-2022 00:00:00 | 21 |
| 22-11-2022 00:00:00 | 16 |
| 22-11-2022 00:00:00 | 46 |
| 22-11-2022 00:00:00 | 80 |
| 22-11-2022 00:00:00 | 57 |
| 22-11-2022 00:00:00 | 49 |
| 22-11-2022 00:00:00 | 88 |
| 22-11-2022 00:00:00 | 81 |
| 22-11-2022 00:00:00 | 19 |
| 22-11-2022 00:00:00 | 100 |
| 22-11-2022 00:00:00 | 1 |
| 22-11-2022 00:00:00 | 5 |
| 22-11-2022 00:00:00 | 29 |
| 23-11-2022 00:00:00 | 45 |
| 23-11-2022 00:00:00 | 12 |
| 23-11-2022 00:00:00 | 58 |
| 23-11-2022 00:00:00 | 95 |
| 23-11-2022 00:00:00 | 85 |
| 23-11-2022 00:00:00 | 50 |
| 23-11-2022 00:00:00 | 18 |
| 23-11-2022 00:00:00 | 60 |
| 23-11-2022 00:00:00 | 47 |
| 23-11-2022 00:00:00 | 74 |
| 23-11-2022 00:00:00 | 93 |
| 23-11-2022 00:00:00 | 44 |
| 23-11-2022 00:00:00 | 95 |
| 23-11-2022 00:00:00 | 69 |
| 23-11-2022 00:00:00 | 34 |
| 23-11-2022 00:00:00 | 16 |
| 23-11-2022 00:00:00 | 38 |
| 24-11-2022 00:00:00 | 98 |
| 24-11-2022 00:00:00 | 35 |
| 24-11-2022 00:00:00 | 25 |
| 24-11-2022 00:00:00 | 33 |
| 24-11-2022 00:00:00 | 5 |
| 24-11-2022 00:00:00 | 32 |
| 24-11-2022 00:00:00 | 100 |
| 24-11-2022 00:00:00 | 11 |
| 24-11-2022 00:00:00 | 36 |
| 24-11-2022 00:00:00 | 24 |
| 24-11-2022 00:00:00 | 10 |
| 24-11-2022 00:00:00 | 26 |
| 24-11-2022 00:00:00 | 69 |
| 24-11-2022 00:00:00 | 26 |
| 24-11-2022 00:00:00 | 72 |
| 25-11-2022 00:00:00 | 83 |
| 25-11-2022 00:00:00 | 23 |
| 25-11-2022 00:00:00 | 2 |
| 25-11-2022 00:00:00 | 17 |
| 25-11-2022 00:00:00 | 77 |
| 25-11-2022 00:00:00 | 49 |
| 25-11-2022 00:00:00 | 6 |
| 25-11-2022 00:00:00 | 15 |
| 25-11-2022 00:00:00 | 9 |
| 26-11-2022 00:00:00 | 1 |
| 26-11-2022 00:00:00 | 43 |
| 26-11-2022 00:00:00 | 4 |
| 26-11-2022 00:00:00 | 66 |
| 26-11-2022 00:00:00 | 92 |
| 26-11-2022 00:00:00 | 91 |
| 26-11-2022 00:00:00 | 74 |
| 26-11-2022 00:00:00 | 1 |
| 26-11-2022 00:00:00 | 90 |
| 26-11-2022 00:00:00 | 70 |
| 26-11-2022 00:00:00 | 65 |
| 26-11-2022 00:00:00 | 43 |
| 26-11-2022 00:00:00 | 82 |
| 26-11-2022 00:00:00 | 66 |
| 27-11-2022 00:00:00 | 86 |
| 27-11-2022 00:00:00 | 58 |
| 27-11-2022 00:00:00 | 53 |
| 27-11-2022 00:00:00 | 6 |
| 27-11-2022 00:00:00 | 99 |
| 27-11-2022 00:00:00 | 29 |
| 27-11-2022 00:00:00 | 19 |
| 27-11-2022 00:00:00 | 4 |
| 27-11-2022 00:00:00 | 74 |
| 27-11-2022 00:00:00 | 99 |
| 27-11-2022 00:00:00 | 57 |
| 27-11-2022 00:00:00 | 17 |
| 27-11-2022 00:00:00 | 42 |
| 27-11-2022 00:00:00 | 79 |
| 27-11-2022 00:00:00 | 64 |
| 27-11-2022 00:00:00 | 90 |
| 27-11-2022 00:00:00 | 44 |
| 28-11-2022 00:00:00 | 9 |
| 28-11-2022 00:00:00 | 91 |
| 28-11-2022 00:00:00 | 48 |
| 28-11-2022 00:00:00 | 18 |
| 28-11-2022 00:00:00 | 41 |
| 28-11-2022 00:00:00 | 7 |
| 28-11-2022 00:00:00 | 65 |
| 28-11-2022 00:00:00 | 6 |
| 28-11-2022 00:00:00 | 55 |
| 28-11-2022 00:00:00 | 18 |
| 28-11-2022 00:00:00 | 17 |
| 29-11-2022 00:00:00 | 37 |
| 29-11-2022 00:00:00 | 68 |
| 29-11-2022 00:00:00 | 6 |
| 29-11-2022 00:00:00 | 2 |
| 29-11-2022 00:00:00 | 91 |
| 29-11-2022 00:00:00 | 73 |
| 29-11-2022 00:00:00 | 7 |
| 29-11-2022 00:00:00 | 19 |
| 29-11-2022 00:00:00 | 93 |
| 29-11-2022 00:00:00 | 54 |
| 29-11-2022 00:00:00 | 7 |
| 29-11-2022 00:00:00 | 78 |
| 29-11-2022 00:00:00 | 86 |
| 29-11-2022 00:00:00 | 63 |
| 29-11-2022 00:00:00 | 4 |
It should not aggregate the values neither it should aggregate the date value.
see my example screenshot.
Hi @imnewpbiuser568 - Hope you already loaded the above sample data provided and have to ensure that date is format is as per your local setting ,
Ensuring that the Date and Values columns are correctly recognized as Date/Time and Numeric data types
Basically , value we have to aggregate it with sum or other aggregated function,
Date as per your locale settings you can configure and load it.
FInal result should be as follow Once loaded the above given data
Line chart with above data:
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
It should not aggregate the values neither it should aggregate the date value.
see my example screenshot.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |