Forum Discussion
Scatter chart alternative
Like this?
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
Like this?
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.
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: