Forum Discussion

jkfe's avatar
jkfe
Frequent Visitor
2 years ago

How to create a line chart without aggregation?

I want to create a line chart that has two lines and a single dot.   This is the data.   Line 1 X1 Y1 10 2 11 3 12 4 13 5 14 6 15 7 15 10     Line 2 X2 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Thanks for the solution HotChilli  provided and i want to offer some more information for user to refer to.

hello jkfe , in Power BI Desktop, the y-axis cannot show the value, you can consider to try the following alternatives.

Change the table to the following format.

Then put the following field to the line chart.

Output

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

jkfe's avatar
jkfe
Frequent Visitor
2 years ago

Anonymous thanks for the answer. This doesn't solve the issue because it creates two separate points in the X-axis and then creates an inclined line from one point to the other. If you see the chart I originally posted, it needs to be a straight line from (15, 7) to (15, 10). So it needs to have two or more Y values for the same X value.