Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.