Scatter chart alternative

[xhead]

I have two measures that I want to plot over time. Average Oil ("Avg Oil (bbl/d)") and Cumulative Oil ("Cumulative Oil (bbl)"). Here is sample of the data:

Date	Avg Oil (bbl/d)	Cumulative Oil (bbl)
10/1/2017	1.61	1.61
10/2/2017	1.65	3.26
10/3/2017	1.61	4.87
10/4/2017	1.61	6.48
10/5/2017	1.73	8.21
10/6/2017	1.72	9.93
10/7/2017	1.67	11.6
10/8/2017	1.64	13.24
10/9/2017	1.68	14.92
10/10/2017	1.54	16.46
10/11/2017	1.72	18.18

I can do this with a Scatter chart, but I really want a line instead of bubbles.

--> I can't upload a screen shot, forum isn't letting me

I tried using an R visual, but I can't figure out what the script should be:

--> my screenshot shows a continuous level line 

# dataset <- data.frame(Date, Avg Oil (bbl), Cumulative Oil (bbl))

library("ggplot2")

ggplot(dataset, aes(x = `Cumulative Oil (bbl)`, y = `Avg Oil (bbl)`)) +
geom_line()

Any ideas? 

Mike

[Greg_Deckler]

Wait, why can't you use a standard Line Chart visualization?

[xhead]

Yeah, I wish I could upload the screen shots. 

A Line chart gives me two lines, one for Avg and one for Cumulative, with 0-200 on the y-axis, and dates on the X-axis.

 , I want the x-axis to show the Avg, and the y-axis to show the cumulative, one line to show the relationship of avg vs cumulative

[Greg_Deckler · Accepted solution]

Like this?

[xhead]

Ok, I can do that too, except that I can't use a (DAX) measure on the Axis or in the Value. I guess that's expected?

I'm used to creating measures on tabular columns and hiding them. 

[Greg_Deckler]

You can probably get there using the disconnected table trick although in your particular case that might be somewhat complicated. The disconnected table trick allows you to use a measure in places where you can't usually use a measure. See this article:

https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...