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

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.

Reply
imnewpbiuser568
Frequent Visitor

Simple line chart with x and y axis non aggregated

imnewpbiuser568_1-1718103942513.png

 


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.

 

 

imnewpbiuser568_0-1718103897191.png
Dummy Table given below.

 

Date                           Values

16-11-2022 00:00:0019
16-11-2022 00:00:0072
16-11-2022 00:00:005
16-11-2022 00:00:0073
16-11-2022 00:00:0085
16-11-2022 00:00:0047
16-11-2022 00:00:001
16-11-2022 00:00:006
16-11-2022 00:00:005
16-11-2022 00:00:0014
16-11-2022 00:00:0012
16-11-2022 00:00:0023
16-11-2022 00:00:0057
16-11-2022 00:00:001
17-11-2022 00:00:009
17-11-2022 00:00:0070
17-11-2022 00:00:0039
17-11-2022 00:00:0029
17-11-2022 00:00:0074
17-11-2022 00:00:0034
17-11-2022 00:00:0098
17-11-2022 00:00:0017
17-11-2022 00:00:0030
17-11-2022 00:00:0063
17-11-2022 00:00:0010
17-11-2022 00:00:005
18-11-2022 00:00:0029
18-11-2022 00:00:0097
18-11-2022 00:00:0028
18-11-2022 00:00:0076
18-11-2022 00:00:0034
18-11-2022 00:00:004
18-11-2022 00:00:0022
18-11-2022 00:00:0033
18-11-2022 00:00:0097
18-11-2022 00:00:0083
18-11-2022 00:00:0037
18-11-2022 00:00:0083
19-11-2022 00:00:0055
19-11-2022 00:00:0093
19-11-2022 00:00:006
19-11-2022 00:00:0044
19-11-2022 00:00:0040
19-11-2022 00:00:0032
19-11-2022 00:00:0050
19-11-2022 00:00:0087
19-11-2022 00:00:0030
20-11-2022 00:00:007
20-11-2022 00:00:0052
20-11-2022 00:00:002
20-11-2022 00:00:0011
20-11-2022 00:00:002
20-11-2022 00:00:0082
20-11-2022 00:00:0070
20-11-2022 00:00:0096
20-11-2022 00:00:0034
20-11-2022 00:00:0055
20-11-2022 00:00:0017
20-11-2022 00:00:006
20-11-2022 00:00:0076
20-11-2022 00:00:0022
20-11-2022 00:00:0012
20-11-2022 00:00:0085
20-11-2022 00:00:0083
20-11-2022 00:00:0084
20-11-2022 00:00:0082
21-11-2022 00:00:0058
21-11-2022 00:00:0022
21-11-2022 00:00:0037
21-11-2022 00:00:0075
21-11-2022 00:00:0078
21-11-2022 00:00:0090
21-11-2022 00:00:004
21-11-2022 00:00:0029
21-11-2022 00:00:0040
21-11-2022 00:00:0079
21-11-2022 00:00:0019
21-11-2022 00:00:0097
21-11-2022 00:00:0033
21-11-2022 00:00:0095
21-11-2022 00:00:008
21-11-2022 00:00:0046
21-11-2022 00:00:0030
21-11-2022 00:00:004
22-11-2022 00:00:0055
22-11-2022 00:00:008
22-11-2022 00:00:0037
22-11-2022 00:00:0083
22-11-2022 00:00:0098
22-11-2022 00:00:0021
22-11-2022 00:00:0016
22-11-2022 00:00:0046
22-11-2022 00:00:0080
22-11-2022 00:00:0057
22-11-2022 00:00:0049
22-11-2022 00:00:0088
22-11-2022 00:00:0081
22-11-2022 00:00:0019
22-11-2022 00:00:00100
22-11-2022 00:00:001
22-11-2022 00:00:005
22-11-2022 00:00:0029
23-11-2022 00:00:0045
23-11-2022 00:00:0012
23-11-2022 00:00:0058
23-11-2022 00:00:0095
23-11-2022 00:00:0085
23-11-2022 00:00:0050
23-11-2022 00:00:0018
23-11-2022 00:00:0060
23-11-2022 00:00:0047
23-11-2022 00:00:0074
23-11-2022 00:00:0093
23-11-2022 00:00:0044
23-11-2022 00:00:0095
23-11-2022 00:00:0069
23-11-2022 00:00:0034
23-11-2022 00:00:0016
23-11-2022 00:00:0038
24-11-2022 00:00:0098
24-11-2022 00:00:0035
24-11-2022 00:00:0025
24-11-2022 00:00:0033
24-11-2022 00:00:005
24-11-2022 00:00:0032
24-11-2022 00:00:00100
24-11-2022 00:00:0011
24-11-2022 00:00:0036
24-11-2022 00:00:0024
24-11-2022 00:00:0010
24-11-2022 00:00:0026
24-11-2022 00:00:0069
24-11-2022 00:00:0026
24-11-2022 00:00:0072
25-11-2022 00:00:0083
25-11-2022 00:00:0023
25-11-2022 00:00:002
25-11-2022 00:00:0017
25-11-2022 00:00:0077
25-11-2022 00:00:0049
25-11-2022 00:00:006
25-11-2022 00:00:0015
25-11-2022 00:00:009
26-11-2022 00:00:001
26-11-2022 00:00:0043
26-11-2022 00:00:004
26-11-2022 00:00:0066
26-11-2022 00:00:0092
26-11-2022 00:00:0091
26-11-2022 00:00:0074
26-11-2022 00:00:001
26-11-2022 00:00:0090
26-11-2022 00:00:0070
26-11-2022 00:00:0065
26-11-2022 00:00:0043
26-11-2022 00:00:0082
26-11-2022 00:00:0066
27-11-2022 00:00:0086
27-11-2022 00:00:0058
27-11-2022 00:00:0053
27-11-2022 00:00:006
27-11-2022 00:00:0099
27-11-2022 00:00:0029
27-11-2022 00:00:0019
27-11-2022 00:00:004
27-11-2022 00:00:0074
27-11-2022 00:00:0099
27-11-2022 00:00:0057
27-11-2022 00:00:0017
27-11-2022 00:00:0042
27-11-2022 00:00:0079
27-11-2022 00:00:0064
27-11-2022 00:00:0090
27-11-2022 00:00:0044
28-11-2022 00:00:009
28-11-2022 00:00:0091
28-11-2022 00:00:0048
28-11-2022 00:00:0018
28-11-2022 00:00:0041
28-11-2022 00:00:007
28-11-2022 00:00:0065
28-11-2022 00:00:006
28-11-2022 00:00:0055
28-11-2022 00:00:0018
28-11-2022 00:00:0017
29-11-2022 00:00:0037
29-11-2022 00:00:0068
29-11-2022 00:00:006
29-11-2022 00:00:002
29-11-2022 00:00:0091
29-11-2022 00:00:0073
29-11-2022 00:00:007
29-11-2022 00:00:0019
29-11-2022 00:00:0093
29-11-2022 00:00:0054
29-11-2022 00:00:007
29-11-2022 00:00:0078
29-11-2022 00:00:0086
29-11-2022 00:00:0063
29-11-2022 00:00:004

@Ahmedx 
@Ritaf1983 
@amitchandak 
@parry2k @lbendlin 

@Ashish_Mathur 
@rajendraongole1 

3 REPLIES 3
imnewpbiuser568
Frequent Visitor

It should not aggregate the values neither it should aggregate the date value.

see my example screenshot.

rajendraongole1
Super User
Super User

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

 

rajendraongole1_0-1718166549469.png

 

 

Line chart with above data: 

rajendraongole1_1-1718166620111.png

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





It should not aggregate the values neither it should aggregate the date value.

see my example screenshot.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.