Line Chart

[BIswajit_Das]

Hello,

I have a table like

x             y                 z

2023       23              22

2022       33              10

2021       20              30

and i want to visualize this data using line chart

Any Ideas
Thanks & Regards

[johnyip]

@BIswajit_Das ,

since you have edited your questions to include "z", please find my asnwer as below.

I don't recommend using secondary y-axis as the scale of y and z would then be different, thus possibly causing confusion when you aim to compare y and z.

[BIswajit_Das]

But when i'm using line chart there's no option for MAX() or anything else

here it's just count and distinct count

[v-yiruan-msft · Accepted solution]

Hi @BIswajit_Das ,

Which field you are applying on Y-axis field of visual? What's the data type of them? Please change the data type as Number. Then you can choose the proper aggregation for that field when create line chart...

Change data type as Number

Create line chart

Best Regards

[Uzi2019]

Hi @BIswajit_Das 
You can visualize using line chart like below.

I have taken your X value on x axis and Y & Z value on y axis.

I hope I answered your question!

[johnyip]