Forum Discussion
Display distance between 2 lines chart as a third line
Hi jinny_le
If you'd like to show 2 products on a line chart at one time, you could add "product name" column into slicer, then select two products each time.
Or you could create tables and add columns to slicer.
product slicer1 = VALUES('Table'[product]) product slicer2 = VALUES('Table'[product]) Measure = CALCULATE(SUM('Table'[price]),FILTER('Table','Table'[product]=[Selected1]||'Table'[product]=[Selected2]))Do you need to add another line to this line chart which shows the difference of price between two products?
Based on my experience, if you add columns to "legend" field of a line chart,
it is impossible to add more than one measure/column into "Values" field,
thus the line numbers showing one the visual are detemined by the legend.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.ddd
Community SupportHi jinny_le
If you'd like to show 2 products on a line chart at one time, you could add "product name" column into slicer, then select two products each time.
Or you could create tables and add columns to slicer.
product slicer1 = VALUES('Table'[product])
product slicer2 = VALUES('Table'[product])
Measure = CALCULATE(SUM('Table'[price]),FILTER('Table','Table'[product]=[Selected1]||'Table'[product]=[Selected2]))
Do you need to add another line to this line chart which shows the difference of price between two products?
Based on my experience, if you add columns to "legend" field of a line chart,
it is impossible to add more than one measure/column into "Values" field,
thus the line numbers showing one the visual are detemined by the legend.
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ddd
hi Maggie v-juanli-msft
Thanks for your detailed guiande. Yes i need to add the price-difference line and i understand the limitation you were talking about. But this output is good enough, so i'll just go ahead with this for now. Thank you 🙂
