Forum Discussion
Cannot display Line Chart in a right way
I have a table where there are mainly 3 components: Timestamp (time), price, and volume; and my main goal is to draw a supply curve using them; As shown below:
When I choose the specific timestamp, prices should align as Y coordinates and Volumes as X coordinates; But due to several reasons, I cannot display them in an accurate way. In the aspect of price as you can see from the screen below, power BI makes me choose if it's "min of price"; "max of price", etc. and from my point of view this is what causes the mentioned mistake.
Could you please tell me how to change maybe column types, or choose another chart which would help me to draw the mentioned supply chart in the right way.
9 Replies
kupradzeg Perhaps try a scatter plot? I guess the question is, what should it look like? If you have the same quantity (volume) at different prices at different times, then how should it display?
Scatter plot does not help as it displays bunch of points that are aligned in a wrong way; The result should look similar to the one displayed in my problem above; The only this is that it skips some points, and misses several details due to the summarization (or other) issue; I want the graph to take every value in volumes and every value in price columns and use them as individual point (So not to skip any, not to summarize, etc. and build a line;)
So I want to have something like an Excel's Scatter with straight lines
Have you tried a scatter chart with timepoint in the detail and id in the legend (and price and quantity on x and y)?
Pat
Unfortunately, I need a line. With the given configuration points are getting in the right way but they are not connected as lines. I built that scatter and just for explanation purposes connected through the line using paint 😄
Power BI builds the graph right when I use the line chart and put the Volumes on Y axis and Prices on the X axis; But I want it to be vise versa (Prices on Y axis and volumes on X) and when I try that several points get lost 😞
