This combines the two tables. Then to plot it on line chart I wrote in Items:
SortByColumns(Dataset3, "X", Ascending)
What I got is this:
As we can see the graph treats blanks in the table as zeros for plotting:
What I would like is for the graph to have only one X value for all 3 series (like for x= 2.2 or 2.5) and to ignore blanks when plotting. So essentially the graph should look like this (made in Excel):
Does that make sense?
Not sure if that's possible to do on a line chart in PowerApps . Any help would be really appreciated.